Units in chart with dynamic measure

[qmest]

Hi,

I've created a line chart that shows a value per year. This value is dynamic and is obtained from a switch statement, in which the user selects a value from a dropdown slicer and the measure adjusts accordingly. This works as intended but the units in the chart, although set to "Auto" do not change. Since this measure can represent percentages or absolute numbers is there a way to have the units change as the user selects the dynamic measure?

Thanks.

[v-yetao1-msft]

Hi @qmest 

Maybe you can achieve dynamic formatting using Format in below way. I found a similar case , you can refer to it .

https://community.powerbi.com/t5/Desktop/Display-unit-for-dynamic-measure/m-p/794800

Best Regard

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[qmest]

Hi,

I'm not sure how this applies to what i'm trying to do? Is there some sort of example that you can provide?

Thanks.

[amitchandak]

@qmest , for that you have to use calculation group, if you format the measure then if will become a text measure

calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/