ChangingDisplay Format Based on a Slicer

[Arne819]

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. 

[Anonymous · Accepted 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

[Arne819]

Ty worked fine for me