Forum Discussion

dbldee5's avatar
dbldee5
Frequent Visitor
2 years ago
Solved

Conditional formatting

If I can get any help with this, it would be awesome. I have a table that has 3 text columns in the rows: Course Modality Part of term   I want to add a conditional format of Red to the Course R...
Need Help
  • dbldee5's avatar
    dbldee5
    2 years ago

    Hi Sam

    WOW!! this is perfect and worked!!

    one more question. This is what the table looks like now.. is there a way to add the same color to the column with the words? on the Course, part of Term and Modality

     

     

     

SamWiseOwl's avatar
SamWiseOwl
Super User
2 years ago

Hi dbldee5  you could do this with a SWITCH and ISFILTERED:
colour measure =
Switch(
true()
,isFiltered(table[Term]) && [Percent] > X,"Green"
,isFiltered(table[Modality]) && [Percent] > X ,"Yellow"
,isFiltered(table[Course]) && [Percent] > X ,"Red")

 

You test the inner most row first and then work outwards.

  • dbldee5's avatar
    dbldee5
    Frequent Visitor
    2 years ago

    Hi Sam

    WOW!! this is perfect and worked!!

    one more question. This is what the table looks like now.. is there a way to add the same color to the column with the words? on the Course, part of Term and Modality

     

     

     

    • SamWiseOwl's avatar
      SamWiseOwl
      Super User
      2 years ago

      I don't believe so sadly 😞

      • dbldee5's avatar
        dbldee5
        Frequent Visitor
        2 years ago

        Hi Sam, 

        I accepted this as a solution. Do you know if I will be able to color the first column with the labels the same way?

        Thanks