Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
abhishek_2593
Helper I
Helper I

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?

abhishek_2593_0-1654778734109.png

 

1 ACCEPTED SOLUTION
NickolajJessen
Solution Sage
Solution Sage

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

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

View solution in original post

2 REPLIES 2
NickolajJessen
Solution Sage
Solution Sage

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

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

Thank you very much 🙂 this helps!

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.