Conditional formatting

[dbldee5]

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

[SamWiseOwl]

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 · Accepted solution]

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]

I don't believe so sadly 😞

[dbldee5]

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