Display Unit

[Anonymous]

Hi

Is there a way to custom display unit?

I want to apply different unit on numbers like the example below.

number: 100,000,000

now: 100millions

wish to be: 1 uk (=100millions in Korean unit)

TY 🙂

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

How about this measure?

Measure = 
IF(
    MAX('Table (3)'[Values]) <> BLANK(),
    MAX('Table (3)'[Values])/100000000 & "UK",
    0
)

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

If you want to format. Then you can use format function or the option in Visualization pane for format.

If you want the conversion. Then either you can use static value to divide or you can have an exchange rate table to do the same.

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601