Fix Display Units Standard, without taking region into account

[FedeB]

Greetings Everyone,

I'm having the following issue regarding the "display units" function in Power BI.

I live in a Spanish speaking country, where the standard suffixes for thousands and millions are "mil" and "mill" respectively. As you can probably tell, this abbreviations are both kinda long, and very similar among themselves. So at first glance it's difficult to tell the difference between them.

In order to solve this I tried changing the Regional Settings in the desktop app, which partially solved the issue. As of now, I managed to make it so when I'm editing my reports I see this suffixes as "K" instead of "mil", and "M" instead of "mill". The problem is that when i publish the reports, this units seem to be linked to the viewing user's settings. This means that I would have to tell every single person I share my reports with, to change their regional settings in their Power BI service (or maybe even make them switch their system's regional configuration).

Is there any way for me to fix these settings in my reports without it depending on each user's parameters?

I know I could create a duplicate measure for each of the values I'm showing in my report, making a custom formatting for them, etc. but that is obviously a very annoying workaround.

I'm hoping I'm just missing some key setting I could play with in order to achieve this.

Thanks in advance!

[v-yalanwu-msft · Accepted solution]

Hi, @FedeB ,

You can try creating a new column, formatting the display style of the number, which is a text format. 

Sale in (K) =
Var TotalSale = SUM('Global-Superstore'[Sales])
Var FinalSale = DIVIDE(TotalSale, 1000)
Var decimals = "0.0"
RETURN
FORMAT ( FinalSale, decimals & "K" )

https://powerbidocs.com/2020/09/26/custom-display-units-in-power-bi/

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.