Forum Discussion
Sort with DAX Function FORMAT
Hello All. Does anyone know when the bug will be fixed for sorting measure values that have the FORMAT() function applied to them?
Thank you all for the responses.
I have a switch that goes bewteen Count and Sum.
when I format for currency it wont sort 😞
Switch (Customer Value) = SWITCH(MAX('(Switch) KPI'[ID]),1,[Switch (Count)],2,FORMAT([Customer (Total Sales)],"$#,##0.00"))
Hi Anonymous,
I'd like to suggest you create a calculated column and setting 'sort by column' property to use the original numeric field as sort order, it can fix the 'sorting issue' text value sorting order.
In addition, you can also try to use the table properties formatting feature to change your measure format instead of use format function, this feature does not change the type of formula result.
Regards,
Xiaoxin Sheng