Forum Discussion
Helper Ihow to apply conditional formatting on blank value in Matrix visual?
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,
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 🙂
4 Replies
- amitchandak
Super User
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
sshokri89Thanks 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
