Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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. 

 

Need Help
Tips and Tricks

3 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    4 years ago

    Anonymous 

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

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

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Community Support
    4 years ago

    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.