Forum Discussion
Solved
Keeping Sort after Auto Unit Change Dax Formatting
Hi All, I have the following which auto changes the units on some matrix visuals when the report being filtered. Sales£ = VAR Tot = Sum('Prod FactSales'[Amount Home]) RETURN IF(ABS(Tot)...
well you are changing it to a text value so it will sort alphabetically if i understand you correctly. Create 2 versions of the column one text and the other number and sort the text column by the number column
well you are changing it to a text value so it will sort alphabetically if i understand you correctly. Create 2 versions of the column one text and the other number and sort the text column by the number column