04-19-2023 08:29 AM
The April 2023 release of Power BI Desktop gave us dynamic format strings for measures. While the end result could be previously accomplished by using calculation groups, we can now have measures with different formats based upon various conditions – no need to go into Tabular Editor to do this now!
While we can use parameters to switch measures, things get more complicated if you need to include more selections such as a Top N filter in the measure for all visuals across a page. You may still need to write your own measure selection logic in cases such as this.
We also recently got the ability to add subtitles underneath the titles of visuals.
This week, we are making a report that allows users to choose both a metric and a number of products to visualize by various dimensions. The visuals must show the measure with appropriate formatting (e.g., whole numbers, percentage with two decimal points, currency).
For more info, see: https://workout-wednesday.com/pbi-2023-w16/