Forum Discussion

jimbob2285's avatar
jimbob2285
Advocate IV
2 years ago
Solved

Matrix, Cell Element, Background Conditional Formatting - don't apply to column totals

I have a matrix, whose rows show types of quotes with a total quotes below (row totals) and the columns are lead times and the values are the number of quotes   I want to conditionally format colum...
Need Help
  • AndrewGould's avatar
    AndrewGould
    2 years ago

    Hi,

    Can you do this with a measure?  Here's a basic example:

     

    Cell Colour = SWITCH(
        TRUE(),
        SELECTEDVALUE('QCD Period L2'[QCD Period L2]) = "Today", "Yellow",
        SELECTEDVALUE('QCD Period L2'[QCD Period L2]) = "1 Month + Past QCD", "Grey",
        CONTAINSSTRING(SELECTEDVALUE('QCD Period L2'[QCD Period L2]), "-"), "Red",
        CONTAINSSTRING(SELECTEDVALUE('QCD Period L2'[QCD Period L2]), "+"), "Green",
        SELECTEDVALUE('QCD Days'[QCD Days]) = "Past QCD", "Red",
        SELECTEDVALUE('QCD Days'[QCD Days]) = "Due", "Green"
    )
     
    You could then assign this to the Background Color conditional format rather than using the rules you defined
     

     

    And the result (sorry about the gross colours!):

     

     

jimbob2285's avatar
jimbob2285
Advocate IV
2 years ago

Thanks Andrew, I thought about using a measure, but couldn't see how it would produce a different result - I would have never got there without your help and didn;t realise you could apply the measure to different levels within the matrix

AndrewGould's avatar
AndrewGould
Frequent Visitor
2 years ago

Excellent, happy to hear that it helped!