Forum Discussion

TerrAustria's avatar
TerrAustria
New Member
2 years ago
Solved

Custom Number Format with Unit gets messed up

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: ...
Need Help
  • PijushRoy's avatar
    PijushRoy
    2 years ago

    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


PijushRoy's avatar
PijushRoy
Community Champion
2 years ago

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's avatar
TerrAustria
New Member
2 years ago

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's avatar
    PijushRoy
    Community Champion
    2 years ago

    Hi TerrAustria 

    I always use same tricks