Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
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?
I'm trying this method with a DISTINCTCOUNT and I'm still getting blanks.
Vendor Count:=IF(ISBLANK(DISTINCTCOUNT([Vendor Sourcing HierarchyVendor Sourcing HierarchyVendorid])),0,DISTINCTCOUNT([Vendor Sourcing HierarchyVendor Sourcing HierarchyVendorid]))
I have a list of stores in my rows, and time period as columns. Some periods, don't have data, some do. The ones that don't have any data (No Values) show up as blanks. I want to seed the blanks with 0's
Thoughts/Help?
@MattAllington wrote:Blank normally indicates the absence of any records that match the result. I guess you could just write an if statement like this
New Measure = if(ISBLANK([Original Measure]),0,[Original Measure])
Add a New Measure.
Assign your expression and " + 0 " at the end.
Ex:
NewMeasure = Sum(Table_Name[Field_Name]) + 0
Hi Misakkk,
Check this out...
Measure= IF(CALCULATE(count(column),column ="condition") >0,CALCULATE(count(column),column ="condition"),0)
+0 works very well for me!!
Matt
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 23 | |
| 23 | |
| 20 | |
| 18 | |
| 14 |
| User | Count |
|---|---|
| 58 | |
| 52 | |
| 42 | |
| 30 | |
| 24 |