Forum Discussion
FORMAT Function error
Please mark my post as solution, this will also help others.
Please give Kudos for support.
TaroGulati , Format the first 2 also, This creates few options as numbers and few as %, that will not work
You can explore calculation group if you need a different format for measure slicer
tabular - Calculation groups
https://docs.microsoft.com/en-us/analysis-services/tabular-models/calculation-groups?view=asallproducts-allversions#limitations
amitchandak thanks for the suggestion. i believe with the help of calculation group, this would not work because that will also return a measure as text and graph doesn't accept the format text.
mwegener thanks for your suggestion.
I think problem is still there.
in your calculation item, you assigned values to each selection of slicer but it is still not showing the values in percentage with % sign on the axis.
i tried to modifiy but still doesn't give the desired result.
Thanks again for your efforts.
