Color Formatting Of Blank Cells Within A Matrix Table

[Collin8579]

Hello,
I have a matrix table that I have broken up with two sets of headers "Milestone bucket" and if it is Managed/Non Managed

I have been able to build in conditional formatting with a measure,

Formatting Measure =

IF(

    ISBLANK(MAX('Datatable'[App])),

    "#D2A9D2",

    IF(

        MAX('Datatable'[Bucket]) = "Pre CM2" || MAX('Datatable'[Bucket]) = "JM29-NTP",

        "#D2A9D2",

        "#99DFF9"

    )

)

But that only gets me color on cells that are populated
I've tried isblank, I've tried normal formatting within the table, etc
I've tried google, chatgpt, and local resources at my company and nobody seems to be able to help me create a way to get alternating colors on a matrix visual like that - 
If I change the conditional formatting to a rule instead of a field I Can highlight blank values

But I can't seem to find a way to do both at once or highlight the blanks the same color as the main columns if they are verigated
I have tried adding +0 to the formulas/columns but that doesn't help

Any help would be appreciated
Collin

[amitchandak]

@Collin8579 , Blank value only works well with the gradient or with rule conditional formatting with the  blank option

As the text formatting is supported in rule-based it should work for you

Rule Based Conditional formatting based on string fields

https://youtu.be/Fq0JneLDbGs

Use +0 measure in visual and true try formatting of that can help