Custom Number Format with Unit gets messed up

[TerrAustria]

Hi guys,

I am having an issue with showing custom number formats in PowerBI.

The goal is to show the Unit of a number, in my case "kWh", so the custom number format I applied to my measure is:

###,###,###,###,###.00 kWh

This works ok until I change the display of numbers in the Visual on the Dashboard to Thousands, Millions, etc.

Then the result looks like this:

You see that "kWh" gets trimmed to "h" at the end for some reason.

Expected result would have been "2,379.32 Tsd kWh"

I tried to escape the unit with "###,###,###,###,###.00 \k\W\h" but this changes nothing.

What can be done?

thanks!

Stefan

[PijushRoy · Accepted solution]

Hi @TerrAustria 

In place of applying Thousand/Millons in visual level.
Please use DIVIDE in measure like
For Thousand = DIVIDE(your measure,1000)
For Millions = DIVIDE(your measure,1000000)

Appreciate your KUDOS/LIKE , If solve your question, mark this answer as SOLUTION

Thanks
Pijush

[TerrAustria]

Hi,

Thanks for your reply!

So this means I just cannot use the visual level fomatting when using custom formats?

Do I understand it correctly that this however would mean that I need to duplicate the measure for each scenario?

Because I show this value in daily, weekly, monthly an yearly reports sometimes I need the standard formating and sometimes thousants or millions.

so:

measure1

measure1_thousant
measure1_million

?

thanks

Stefan

[PijushRoy]

Hi @TerrAustria 

I always use same tricks