Single Conditional formatting measure based on multiple columns

[akhilduvvuru]

Hi Team, I have a requirement to create ONLY ONE conditional formatting measure that should check values in around 10-15 Class fields (Class1, class2, class3, class4..... Class10) and format Student (Student1, Student2, Student3, Student4 ..... Student10) fields accordingly.

Here is how my data looks like 

Students1	Class1	Students2	Class2	Students3	Class3	Students10	Class10
S1	C1	S1	C1	S1	C1
S2	C2					S2	C2
S3	C3	S3	C3
S4	C4			S4	C4
		S5	C5			S5	C5
S6	C6

So my measure should work like, out of these 10 or 15 class fileds, wherever I find

C1 then my corresponding S1 value should be in "Red"
C2 then my corresponding S2 value should be in"Green"

C3 then my corresponding S3 value should be in"Amber"
C4 then my corresponding S4 value should be in"Grey"

C5 then my corresponding S5 value should be in"Blue" etc.,

Note: I strictly don't want to create one measure for each class.

Can someone please help me with the same? Thanks!

[akhilduvvuru]

@amitchandak @Greg_Deckler - Appriciate if you have any inputs here. Thanks!

[Idrissshatila]

Hello @akhilduvvuru ,

In the feb 2023 update, they've changed in the conditional formatting so you could set it based on the fields,

check it out https://powerbi.microsoft.com/en-us/blog/power-bi-february-2023-feature-summary/#post-22137-_Toc1269...

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍

Follow me on Linkedin

[akhilduvvuru]

Thanks for your response @Idrissshatila - But my requirement is I only show student fileds in the visualization but my conditional formatting for student fields should be based on class fields.