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
Pbiuserr
Post Prodigy
Post Prodigy

Comparision/Benchmark chart

Hello, 
I would like to prepare a comparision/benchmark chart like one down below, where "Presence" bar is filtered by "Presence" filters and it doesn't change "Benchmark line" values and vice versa - "Benchmark lines" filters changes % on "Benchmark line" but doesnt change "Presence" bar. The measure used in both will be the same, but business will compare for instance Presence of Category = "Audio" with Benchmark line of Category = "TV". Hope it clarifies a bit. I'd also mention that Product and Category are from different tables if that counts

 

Pbiuserr_0-1658219832473.png

 

Thank you in advance for your help

 

2 REPLIES 2
amitchandak
Super User
Super User

@Pbiuserr , Refer if this can help

Compare Categorical Data Using Slicers - Compare two Brands: https://youtu.be/exN4nTewgbc

Thanks. What if instead of Brand I have like 5 columns which I want to compare? How to create such measure

I understand and can recreate this on single slicer but I'd need few of them

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.