Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |