Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I created a measure slicer with reference here:
The issue I encountered here is formatting.
Sinse the report format of my measures incluede both percentage and whole number,
I tried to set by FORMAT in DAX to percent or whole number accordingly, but it will then be turned into text format, which cause sorting problems.
the measure table
you can set the format of of measure before using DAX FORMAT:
the format is fixed to text after using FORMAT, which causes sorting problem:
I tried to use FORMAT in measure table but didn't work either.
The solution I coming up with is to seperate them into two "measure table",
ex: Feb.18_percentage and Feb.18_wholeNumber
Any ideas to avoid the sorting issue ?
Thanks~
Solved! Go to Solution.
From my understand you have reached the current limitation. I don't believe there is presently any way to set up a dynamic formatting for the Measure without changing your measure to Text and making use of the FORMAT function to convert the result into a string of text that you are happy with.
From my understand you have reached the current limitation. I don't believe there is presently any way to set up a dynamic formatting for the Measure without changing your measure to Text and making use of the FORMAT function to convert the result into a string of text that you are happy with.
Got it, thanks man !
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |