Forum Discussion

Tobz007's avatar
Tobz007
Frequent Visitor
2 years ago
Solved

Matrix Table Background Conditional Formatting

Hello Community, I have a matrix table that uses a parameter for the rows, the parameter contains 4 hierachies. The columns are based on weeks e.g Jan 1 - 7, Jan 8 - 15, etc. I am trying to conditio...
General Comment
Need Help
  • Tobz007's avatar
    Tobz007
    2 years ago

    For anyone interested in how I got it to work, this was the final DAX

    Colour Format =

    VAR rStart = SELECTEDVALUE(Table[ResourceStart])
    VAR rEnd = SELECTEDVALUE(Table[ResourceEnd])

    VAR weekStart = SELECTEDVALUE(Table[WeekStart])
    VAR weekEnd = SELECTEDVALUE(Table[WeekEnd])


    VAR _Result =
         SWITCH(
             TRUE(),
                  rStart >= weekStart && rStart <= weekEnd && rEnd >= weekStart && rEnd <= weekEnd, "#FFA07A",
                  rStart >= weekStart && rStart <= weekEnd , "#ADD8E6",
                  rEnd >= weekStart && rEnd <= weekEnd , "#006884",
              " "
          )

    RETURN
          _Result

Tobz007's avatar
Tobz007
Frequent Visitor
2 years ago

For anyone interested in how I got it to work, this was the final DAX

Colour Format =

VAR rStart = SELECTEDVALUE(Table[ResourceStart])
VAR rEnd = SELECTEDVALUE(Table[ResourceEnd])

VAR weekStart = SELECTEDVALUE(Table[WeekStart])
VAR weekEnd = SELECTEDVALUE(Table[WeekEnd])


VAR _Result =
     SWITCH(
         TRUE(),
              rStart >= weekStart && rStart <= weekEnd && rEnd >= weekStart && rEnd <= weekEnd, "#FFA07A",
              rStart >= weekStart && rStart <= weekEnd , "#ADD8E6",
              rEnd >= weekStart && rEnd <= weekEnd , "#006884",
          " "
      )

RETURN
      _Result