Conditional Formatting - Age groups

[abhishek_2593]

I have a dataset of multiple teams with different age groups named as U5, U6 ..... to U16.
How do i use formatting to highlight only a few selected age groups for each team in the matrix chart?

for Ex - U12, U15, U18, U7 etc?

[NickolajJessen · Accepted solution]

SWITCH(
    SELECTEDVALUE('Table'[UCategory]),
    "U12", 1,
    "U15",1
    // and so on
)

Then use conditional formatting to color everything yellow, where it equals 1

[abhishek_2593]

Thank you very much 🙂 this helps!