Dynamic measure selection and formating

[Ivan93l]

Hello everybody,

Hope you can  help me with this.

I have a slicer that allows the user to select the measure to be displayed in some line charts( ex: total sales or % of sales ).

This works fine and if the users choose a measure it will change the value of the line chart.

Till now everything is fine, but I need to also format the values that are displayed. I have integers, percentages, currency...

I cant add the format function because it wont because it transform the value to a string.

I also tried with calculation groups and it changes the measure format but it changes the tooltip values as well. I do not want that because I have some Period Over Period calculations in there.

This questions is quite similar to mine:

No Chart Values if DAX format? - Microsoft Power BI Community

Thank you in advance.

[amitchandak]

@Ivan93l , Not very clear. See if  Calculation groups can help
https://docs.microsoft.com/en-us/analysis-services/tabular-models/calculation-groups?view=asallprodu...

[Ivan93l]

Hello, thanks for your reply.

Here is more or less what I ask No Chart Values if DAX format? - Microsoft Power BI Community