Forum Discussion
Percentage not properly sorting
I have a table that is sorting the percentages I have calculated as text instead of a number. However, I am not sure how to fix this. Ratio Returned to Produced = FORMAT(DIVIDE(counta(RootCause_Q...
The format transform your number to Text.
If you want to change your Measure to Percent do this:
-Delete the Format Function in your measure
-Select your measure
-Go to Modeling
-Format -- Percentage
"-Delete the Format Function in your measure"
When I perform this step it breaks my table visual and when I click on my measure and go to the modeling tab the only format I can choose is text.