topic Re: Formatting a number as a multiple with an "x" at the end - 0.00x in DAX Commands and Tips

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

ompowerbi — Thu, 06 Apr 2023 17:51:55 GMT

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!

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

OwenAuger — Thu, 06 Apr 2023 21:44:59 GMT

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?

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

FreemanZ — Thu, 06 Apr 2023 23:26:06 GMT

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-desktop

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

Anonymous — Tue, 11 Apr 2023 05:43:56 GMT

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