Forum Discussion
Conditional formatting for values in a Matrix visual based on the date
Hello, I am currently trying to create a matrix visual where each column is a month and have the conditional formatting shade certain values in based on the month they are in. Eg. for this visual...
That solution is viable, however the solution I found worked best was ranking the months and adding the condition that way as so:
Eg.
Conditionalformatting =
Var selectedmonth = SELECTEDVALUE('DateTable'[Date (bins)])
Var ranktable = ALLSELECTED('DateTable'[Date (bins)])
Var Productrank =
RANKX(ranktable, 'DateTable'[Date (bins)], selectedmonth)
Var CF = if(Productrank < 7, "Light blue")
Return CF
Thank you for youre response