Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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
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
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
86 | |
85 | |
68 | |
67 | |
63 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |