Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 !
User | Count |
---|---|
128 | |
108 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |