Selectedmeasure() from calculation group changes formatting of all columns in table

[paulyforde]

Hi,

I have a Table that has two % formatted measures like the below.

When I make a selection on the slicer, all columns format as $ (or the dynamic format set for the calculated item) i.e BoundGWP is $

I have used the folwoing to pull through the formatting and allow me to select the selectedmeasure's 'name' for dynamic chart titles etc:

It works well for charts and tooltips.

Is there a way I can get the value to appear in a table w/o all the other columns geting formatted ?

Any help/advice appreciated.

Thanks,

Paul

[v-zhangtin-msft]

Hi, @paulyforde 

Please check out the following links and hope it will be helpful to you.

Controlling Format Strings in Calculation Groups - SQLBI

Best Regards,

Community Support Team _Charlotte

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