Forum Discussion

shihwenwu's avatar
shihwenwu
Frequent Visitor
8 years ago
Solved

Sorting issue while using a measure table

Hello,

 

I created a measure slicer with reference here:

https://community.powerbi.com/t5/Community-Blog/Dynamically-change-the-information-within-a-visual-via-a-slicer/ba-p/87027

 

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~

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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.