'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

'How convert "blank" to 0 in a card in Power BI with live connection with analysis services?

Solution 1:[1]

Solution 2:[2]

Sources

Related Questions

Solution 1:^[1]

Solution 2:^[2]