Forum Discussion
Dynamic measure selection and formating
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:
Thank you in advance.
2 Replies
Ivan93l , Not very clear. See if Calculation groups can help
https://docs.microsoft.com/en-us/analysis-services/tabular-models/calculation-groups?view=asallproducts-allversions#limitationsHello, thanks for your reply.
Here is more or less what I ask No Chart Values if DAX format? - Microsoft Power BI Community
