Changing the background colour for Matrix visual column having no value for todays date.

Hi chiru5262 ,

In your scenario, conditional formatting cannot work on blank value, so we need to do this:

Sample data:

1. Create table tables.

Category = DISTINCT('Table'[Category])

Dates = CALENDAR(DATE(2020,8,1),DATE(2020,8,31))

2. Create relationships among the three tables.

3. Create a Martix visual.

4. Create a measure.

1 = IF(MAX(Dates[Date])=TODAY(),1)

5. Set conditional formatting.

We can find that when value is blank, conditonal formatting doesn't work. So, we need to put the Measure "1" to the matrix, too.

It works now. Then, we can hide this measure. Try this:

Next, we can also try to hide to column name of "Value".

In addition, regarding why we need to create another Dates table, I think this screenshot can explain:

BTW, .pbix file attached.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.