Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi there, I was wondering if I could make a user select a unit, e.g., Mio, Tsd and it would automatically change over the report. I was thinking about making a measure with a switch based on a parameter. But this would mean I would need a lot of measures. In the picture below, I show what I want. So my question is: Is there a more elegant way or an option that I missed? Thanks for taking the time to read this.
Cheers Arne.
Solved! Go to Solution.
Hi @Arne819,
I'd like to suggest you take a look at the dynamic formatting string features:
Create dynamic format strings for measures in Power BI Desktop - Power BI | Microsoft Learn
If the above not helps, you can also try to use field parameter with calculate groups to achieve dynamic format:
Field parameters in cooperation with Calculation groups (linkedin.com)
Regards,
Xiaoxin Sheng
Hi @Arne819,
I'd like to suggest you take a look at the dynamic formatting string features:
Create dynamic format strings for measures in Power BI Desktop - Power BI | Microsoft Learn
If the above not helps, you can also try to use field parameter with calculate groups to achieve dynamic format:
Field parameters in cooperation with Calculation groups (linkedin.com)
Regards,
Xiaoxin Sheng
Ty worked fine for me
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
98 | |
97 | |
73 | |
72 |