Forum Discussion

jrmemelink's avatar
jrmemelink
Frequent Visitor
3 years ago

Conditional Formatting background cells in Matrix based on multiple column conditions

Dear community,

I would like to format the background colour of a matrix based on a lower and an upper limit that is specified per combination.

For every combination there is a first sticking day and a last sticking day specified, and all days that fall below the lower limit or above the upper limit should be coloured red. 

 

Then I will insert the amounts by a measure which will show the "actuals" per day of the week. Preferably this happens within those same coloured cells.

 

In below screenshot i've tried to demonstrate this for the first 4 combinations. The cells of the column values "Day no." should be coloured for the lower limit and upper limit that is specified per combination by "MD_FirstStickingDays" and "MD_LastStickingDays" respectively. 

 

Thanks a lot in advance!

 

Need Help

2 Replies

    • jrmemelink's avatar
      jrmemelink
      Frequent Visitor
      3 years ago

      Hi v-luwang-msft,

      This is not it unfortunately. 
      I added the desired outcome in my post. Im not familiar with uploading data through this community, so i created a link through wetransfer: https://we.tl/t-k7w5WOx08e 
      (Important to note is that column numbers 1-7 are given by another data table which is connected to the data through Column MD_LastStickingDay
      I think the way how to do this is by creating a measure for each Column if it is lower than or equal to MD_LastStickingDay, but have not figured out how to do so. Next step (i think) would be to do conditional formatting based on that measure. 

      Any help is welcome!