'How convert "blank" to 0 in a card in Power BI with live connection with analysis services?
i have a dashboard in power bi that take data from analysis services. The problem is that can't show a 0 in a card when there aren't values for this filter. in change show "Blank". Is there a way to show 0 instead of "blank" by some calculation in analysis services?
Solution 1:[1]
You can hide the blank value using a Conditional Formatting rule on the Call Out 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 on the value: https://youtu.be/Xsmbfpa4oCA
Cheers, Bianca
Solution 2:[2]
You can use a measure for this.
Measure1= IF(ISBLANK([Measure]),0,[Measure])
Same if its based on a column. Implement the condition inside the measure.Or you can create a new column.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Bianca Gilchrist |
| Solution 2 | Ilias Stefanidis |