Forum Discussion
Single Conditional formatting measure based on multiple columns
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!
3 Replies
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-_Toc126917169
If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍
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.
amitchandak Greg_Deckler - Appriciate if you have any inputs here. Thanks!
