This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
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
Check out the May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 27 | |
| 25 | |
| 25 | |
| 21 | |
| 14 |
| User | Count |
|---|---|
| 50 | |
| 44 | |
| 20 | |
| 18 | |
| 18 |