Conditional Formatting of blank cells in Matrix

[EpicTriffid]

Morning all,

I have the following matrix (cropped to preserve data security):

I have courses on the left, then years classified as Actuals and Forecast. What I want is to be able to colour all columns in the Actuals category to be coloured grey, but no matter what I do, I can't get those blank cells to colour in. 

I have ISBLANK, = BLANK(), = "", but nothing works. I can't make those blanks read 0 as they have to stay blank. I realise that I can use the "Rules" conditional formatting to colour in blank, but can see that there are also blanks under Forecast, which shouldn't be coloured. So I need that functionality but through DAX so I can omit certain criteria.

[MarioCoppola]

If you use to add 0 you will be able to format blank cell but you must mange blank rows that will appear too, in that case you can filter blank rows defining a filter on measure 

[SJL007]

Try this. 
This solution works on PBI July 2023 Update. (not sure if it was available in previous versions)

[EpicTriffid]

Hi @amitchandak 

I have tried that and there is absolutely no change to the matrix whatsoever. I can only assume that the blanks are coming from the fact that a row does not exist in the data for that cell to be populated. But I would have assumed that a + 0 would fix that?

[amitchandak]

@EpicTriffid , We have that option in gradient as of now. Measure(field value) Based we can not do that.

Have measure +0 and try to color that

How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...