Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Conditional Formatting - Age groups

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? ...
Need Help
Show and Tell
Tips and Tricks
  • NickolajJessen's avatar
    NickolajJessen
    4 years ago
    SWITCH(
    SELECTEDVALUE('Table'[UCategory]),
    "U12", 1,
    "U15",1
    // and so on
)

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

NickolajJessen's avatar
NickolajJessen
Solution Sage
4 years ago
SWITCH(
    SELECTEDVALUE('Table'[UCategory]),
    "U12", 1,
    "U15",1
    // and so on
)

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you very much 🙂 this helps!