Color the blank values apperaing in the Matrix visual?

[Anmolgan]

I want to add a specific color to all the blank values that comes in my matrix table, now i am using 4 level of hirearchy and i want to add conditonal 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:

Any bright ideas how can I do this?

[amitchandak]

if the values are coming blank the create a measure like this

Color COGS= if(isblank(AVERAGE(Table[COGS])),"red","white")

The in conditional formatting under advance control choose the field and then choose this measure.

You have to create three measures(or one measure can handle all) and apply them to all the columns.

Refer :https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-based-on-a-calc...

[Anmolgan]

@amitchandak It does not works in my case and gives me everything in red and my blank fields are not coming as red.

[Greg_Deckler · Accepted solution]

Perhaps like the screen shot below? PBIX is attached.

[Anmolgan]

@Greg_Deckler I was able to twick the problem using your message. Thanks for the help.

[Greg_Deckler]

Great!

[Anmolgan]

@Greg_Deckler Well in my case as you can see in the screenshot, I dont have any text fields in my value section and all of them contains a numerical field, please elaborate how can i achive in this scenerio?