Formatting a number as a multiple with an "x" at the end - 0.00x

[ompowerbi]

Hi, 

I have numbers where I want to add an "x" at the end. I understand I can format this as FORMAT([Number], "0.00x"), however, this changes the data type to text whereas I still want this to be treated as a decimal number as a data type. If I try and order this number by size, Power BI instead orders them as text, i.e. by the order of the first number - 1,2,3,4.... Is there a way to format numbers in this way (0.00x) whilst maintaining the data type as an integer?

Thanks for your help!

[Anonymous]

Hi @ompowerbi,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[FreemanZ]

hi @ompowerbi 

you can add a calculated column with

FORMAT([Number], "0.00x")

Then sort the new column by the original number column.

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column?tabs=powerbi-deskto...

[OwenAuger · Accepted solution]

Hi @ompowerbi 

You can apply the same format string you passed to the FORMAT function as a measure format string instead.

See here

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings

Does that work for you?