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

Question

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?

Answer 1

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.

Answer 2

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