Number Sorting and Formatting

[waitehamrick]

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. 

[v-chenwuz-msft]

Hi @waitehamrick ,

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.

[Fowmy]

@waitehamrick 

You should be able to do it with Calculation Group and Format String Measure in Tabular Editor 

[waitehamrick]

can you provide more detail about how you can do this? I didnt think Tabular Editor allowed for dynamic formatting (K, M, B etc).