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?

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

 

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

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

2 Replies

  • 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

      Thank you very much 🙂 this helps!