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:

 

###,###,###,###,###.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

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


3 Replies

  • 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