Power BI Hack – Maintain Drill Level When Switching Field Parameters – Part 2

In this follow-up post, we delve deeper into maintaining drill levels in Power BI visuals when switching field parameters. While the previous hack was useful for certain scenarios, this guide explores an “old school” method using disconnected tables and measures with the SWITCH and TREATAS functions. This approach was essential before field parameters were fully supported in October 2024. By creating a calculated table and measures, users can dynamically display fields and maintain drill levels effectively.

Read More

Things I Hate About Power BI

This post highlights three frustrations with Power BI: 1) Column chart data labels not adhering to the Outside End position, requiring workarounds. 2) Dual-axis charts lacking an intuitive way to align scales, making comparative analysis difficult. 3) Consistently slow response times when creating new columns or measures, hampering productivity.

Read More