how to apply conditional formatting on blank value in Matrix visual?

[sshokri89]

Hi all,

Below is snapshow of my matrix value. I have applied the below conditional formatting on my single value. but the second rule I am applying is not working. I simply want to show if there is data , show a green checkmark, and if blank, show a red cross; however, it's not working the way I want. any ideas?

Thanks in advance,

[amitchandak]

@sshokri89 , Blank will not work.

Try like this create a new measure

Sum(Table[Act Sales]) +0 

and then do conditional formatting using this measure

You can use you current measure in visual

[sshokri89]

Thanks for the reply but I have already tried this. didnt work. I have created the measure as the left column, and then create the conditional formatting based on it. but didnt work

additionally, I recreated the conditional formatting on [act_sales] based on the measure and still didnt work:

[amitchandak]

@sshokri89 , Can you make all of them as numbers. Some of them are in percent

[sshokri89 · Accepted solution]

I actually did but it didnt work. when I pressed apply, it automatically change them to percent. however, I found the solution:

when conditional formatting, the second rule, I need to set it to "is blank" :

@amitchandak  thanks anyways 🙂