Color the blank values for same rows appearing in the Matrix visual?

[freakinaditya]

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!!

[amitchandak · Accepted solution]

@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

[Anonymous]

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

[Anonymous · Accepted solution]

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.

[amitchandak · Accepted solution]

@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

[freakinaditya]

@amitchandak 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

[freakinaditya]

Can't add +0 as all values are in the text format.