How to replace (Blank) on card when using Live Connection

[Reza]

Hi,

The Card visual shows (Blank) when there is no data. 

I know it is possible to use a new measure to replace that but that is not an option with Live Connection to multidimensional SSAS.

We could replace Null with 0 in our cube but that is not desirable at all as this shows all null records with 0s.

Is there anyway to fix this issue or just have to ask for new feature and wait forever for that to be implemented? 

Really appreciate any help.

[Anonymous]

Hi, 

You can hide the blank value using a Conditional Formatting rule on the Callout 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: https://youtu.be/Xsmbfpa4oCA

[v-juanli-msft]

Hi @Reza

As tested, this formula can help when using live connection.

Measure = IF(ISBLANK(MAX([forcast])),0,MAX([forcast]))

Best Regards

Maggie

[Reza]

Hi @v-juanli-msft,

I am afraid but I cannot add any new measure when using live connection to a multidimensional cube. 

Everything under modeling is disabled. 

Would be any other solution for this?