Forum Discussion
ChangingDisplay Format Based on a Slicer
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.
- Anonymous3 years ago
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
2 Replies
- AnonymousNot applicable
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
- Arne819Frequent Visitor
Ty worked fine for me