Forum Discussion
Number Sorting and Formatting
Hi, Does anyone know how to show a measure number that is abbreviated but still be able to sort in a table based on the number? I trying to do this in the Abbreviated Amount column.
Hi Anonymous ,
No, it no possible to do that. Formatted numbers are text, sorted alphabetically only.
However, you can create a calculated table and sort the abbreviated account column by account column.
Or You can submit your idea to the Power BI Ideas.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.