Why Power BI doesn't have an additional number format for BLANKs?????

[pagen]

Whi Power BI doesn't have an option to format numbers for blanks? For example, the format to be something of the sort [positive_number_format];[negative_number_format];[zero_format],[blank_format] ("#,##0;-#,##0;-;-"). 

I'm forced to create a measure special for cards (add 0 at the end or use isblank) and a different measure for others, doesn't make any sense. (the card measure will return 0 for all the records and cannot be used properly in a matrix for example)

Oh, and another one, why I can't use the colours in the format (for example [RED]), why do I have to add two rules for each visual when I can do it in one go?!?

[Ritaf1983 · Accepted solution]

Hi @pagen 

One of the features that were added to the last versions of power bi desktop is dynamic measures formatting.
It allows you to format your numbers and keep their numerical value.
More information is here :
https://www.youtube.com/watch?v=ROyVkQ9v

And I gave a step by step instructions on how to implement it in the linked post, include a sample file :

https://community.fabric.microsoft.com/t5/Desktop/How-to-dynamically-format-numbers-currency-and-abb...

color formatting is also possible with one step, you can use DAX measure with the condition as a flag, something like :
if [your measure] <0,1,0

and use this measure as a rule

You can suggest/vote for additional ideas in the link if the solutions are not satisfactory.
https://ideas.fabric.microsoft.com/ideas/search-ideas/?q=numbers%20formatting&forum=2d80fd4a-16cb-41...

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