Forum Discussion
Helper IIColor the blank values for same rows appearing in the Matrix visual?
I want to add a specific color to all the blank values that come in my matrix table, now I am using 3 levels of hierarchy and I want to add conditional colors on all those blank values, a sample is given below where I need to add colors only to those values that are appearing as blank:
I want to make the background color for blank values the same as that of previous cells (ie gray) for the same specific rows. But I am not able to achieve it.
Can someone help with it? Thanks in Advance!!
freakinaditya , if the values are blank, power bi do not take that in conditional formatting even in a color measure using is blank
Add +0 to measure and then use conditional formatting How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4
Hi freakinaditya ,
You could select the format tab and set the background color under conditional formating.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
- amitchandak
Super User
freakinaditya , if the values are blank, power bi do not take that in conditional formatting even in a color measure using is blank
Add +0 to measure and then use conditional formatting How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4
freakinadityaamitchandak There is a user requirement so I can't add +0 to show values. All is that they wanted blank values only and background color of blanks values same as that of the background color of values, to maintain the consistency.
- amitchandak
freakinaditya , do one thing, create a measure with +0 and use that in conditional formatting, not in the display (using field value option) , see if that can work
Hi freakinaditya ,
You could select the format tab and set the background color under conditional formating.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi freakinaditya ,
Sorry to disturb you...
But did I answer your question ? Please mark my reply as solution. Thank you very much.Best Regards,
Stephen Tao