Forum Discussion

Reza's avatar
Reza
Helper II
8 years ago

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

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.

Need Help
Tips and Tricks

3 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    8 years ago

    Hi Reza

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

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

     

     

    Best Regards

    Maggie

     

    • Reza's avatar
      Reza
      Helper II
      8 years ago

      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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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