Highlight row in a matrix base on today's date

[Anonymous]

Hi to all. here is another question for all of you.

I Have a Matrix with data : 

I want to highlight row 3 because today is day 3. and then tomorrow highlight they 4. is that possible any ideas?

[jdbuchanan71 · Accepted solution]

Hello @Anonymous 

You will need a measure that compares the day of today to the DaysFrom

RowFormat =
VAR DayNumber =
    SELECTEDVALUE ( 'Date'[DaysFrom] )
RETURN
    IF ( DAY ( TODAY () ) = DayNumber, 1 )

Then apply conditional formatting based on that measure to your value.

[Anonymous]

amazing! Thanks for the help,

Another question, Can I apply that to grand total and row header?

[jdbuchanan71]

Right now the conditional formatting can only apply to the values in the grid, not any of the totals, sub-totals, or headers.