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
Icon for Super User rankSuper 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
    Icon for Super User rankSuper 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