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 Row if it is a certain percent filled

I want to add a conditional format of Yellow to the Modality row if it is a certain percent filled

I want to add a conditional format of Green to the Part of Term row if it is a certain percent filled

 

 

 

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

     

     

     

4 Replies

  • 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