Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
shihwenwu
Frequent Visitor

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-v...

 

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

measure table.PNG

 

you can set the format of of measure before using DAX FORMAT:

measure_before_formatting.PNG

 

 

the format is fixed to text after using FORMAT, which causes sorting problem:

meaure_after_formatting_LI.jpgsortingProblems.PNG

 

 

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~

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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 !

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.