Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
My dashboard showed "(BLANK)" as the value in a card visualization - when I really wanted to see "0".
Is there a best practice to deal with this, or a simple way to adjust this?
Here is my current solution.
Note: This does not seem to be a data type issue. The card is calling on a measure that is calculated as follows:
Total CRs that have moved to P = CALCULATE([Total CRs - for calculations], 'Release_CRs_Systems (CRs Moved Only)'[Friendly System Name] = "P")
2) The data type for "Total CRs - for caculations" is "Whole Number"
3) [Total CRs - for calculations] is a SUM function - type "Whole Number"
CURRENT SOLUTION:
Create a new measure that evaluates [Total CRs that have moved to P] and uses IF(ISBLANK)
DISPLAY CALC FOR CR IN P =
IF( ISBLANK('Release_CRs_Systems (CRs Moved Only)'[Total CRs that have moved to P])
, 0
, ( 'Release_CRs_Systems (CRs Moved Only)'[Total CRs that have moved to P]))
*****
Can anyone provide a more elegant solution?
Create a simple Measure.
A measure Is just like a column in the data which you can add logic expression.
My problem was counting rows and then the output was blank.
I solved by;
I have done it this way as well.
Hi,
You can hide the blank value using a Conditional Formatting rule on the Callout Value. The rule is 'if blank' then select the same color as the card or canvas background.
I have created a video tutorial on how to create the conditional rule: https://youtu.be/Xsmbfpa4oCA
This only works if you have a singular color background/fill. Is there a solution to this if you have a gradient fill background? I'd like to simply display nothing for the value instead of the text (Blank) in the card.
Hi, I cant say its a great solution, but I found that applying a conditional formatting to the 'Callout value' solved it for me.
for a card Visual: --> Format Visual --> Callout Value --> colour (fx)
Then set Format style to Rules, field based on whatever column you are counting from, summarization: Count--> and set 2 rules:
1: If Value Is blank --> set the text colour to the same as the background it is on
2: if value > 0 Number and < 10000000 Number --> then colour to whatever colour you want the text when it isnt 0/blank
This is how I do it as well. I have found it to be the least complicated and straight forward approach. I agree it seems as thought this could just be a setting in Power BI. Also, I have only applied the first (Is Blank) rule above without the 2nd rule and it seems to work just fine.
I agree, this has saved me from recreating all my output values as measures which I don't think should be necessary.
I applied the second rule in my case as without it the text colour default to Black (for me it did at least), where as I needed mine to be white text.
Thanks, It works. But I have to say this is so stupid. Why the hell is power bi missing so many features.
Use the Card (new) visual in Power BI inbox visualizations. In this new visual, you can customize to achieve this "0" value (or any custom value desired) by following configuration in Format Visual section:
Visual tab > Callout Values > Values > Show blank as: 0
Generally i agree with you. It looks really awkward
For the card(s) with (blank), go to Data label
1. Right click on color of the Data label
2. Choose conditional formatting
3. on Format By drop down choose Rules
4. on Base on field choose the field that is used for the card in question
5. Choose appropriate Summarization you want (I chose Sum)
6. Under Rules select drop down if value and choose is blank
here is the trick. my cards are for heat map with 5 by 5 cards for a total of 25
quadrant 1x1 is green, so for that card my choise is
is value = is blank so I choose color gree which hides the Data Label of (Blank)
Great idea! Thank you!
This worked perfectly for me.
If I use the card visual in relation to 'gender', I am having issues solving the blank dillemma because there is no zero value in my data, its either male or female. On my dashboard, when I click the male icon the female icon will appear as blank and vice versa. Ideally when I click on the male icon I would like the female icon to appear as "N/A" or "Zero" is anyone able to help me with this issue I am having, any help is greatly appreciated 🙂
Similar issue here, dealing with non-numeric values.
It'd be nice if you could conditionally format the card, so if it have no data to present, I can conditonal the background color and text color as same, creating the illusion that nothing is presented on the card.
Just add + 0 after your measure for e.g. "Your Measure" + 0.
This generally works for me but didn't with my gauge visual. Might be user error.
Hi even though it seems you have solved this issue , this might be helpful for you to understand the scenario
http://powerbidax.com/how-to-deal-and-remove-blank-and-nan-value-in-power-bi/
Has someone created a suggestion to add functionality to the fields to add a 0 if blank? Creating a measure for every card is too excessive and limits functionality......
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
87 | |
85 | |
67 | |
49 |
User | Count |
---|---|
135 | |
112 | |
100 | |
66 | |
62 |