Forum Discussion

emarc1's avatar
emarc1
Icon for Advocate II rankAdvocate II
5 years ago
Solved

Conditional formatting of matrix date columns

I'd like to highlight date columns in a matrix if they contain today's date. My current solution is to use conditional formatting rules based on a measure that calculates if today falls within the da...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    emarc1 , Power bi does not color blank rows. I tried a color measure with isblank too.

     

    Try if this can work

     

    Today in Date Range =
    VAR minDate = MIN( 'Calendar'[Date] )
    VAR maxDate = MAX( 'Calendar'[Date] )
    RETURN
    IF( TODAY() >= minDate && TODAY() <= maxDate && [measure]+0 <> blank() 1, 0 )

     

    measure is the value you are using in matrix

emarc1's avatar
emarc1
Icon for Advocate II rankAdvocate II
5 years ago

Hmm, I suspected that might be the case. I did experiment with your code amendments but didn't have any luck. I think the only way to do it would be to replace all blanks with zeroes (in the value measure), which would probably result in performance issues instead. It's a shame, because being able to dynamically highlight certain time periods feels very useful, from a UX perspective.

Thanks for your help.