Forum Discussion
Color Formatting Of Blank Cells Within A Matrix Table
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
1 Reply
Anonymous , 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
Use +0 measure in visual and true try formatting of that can help
