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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
hoyt22
Helper I
Helper I

Grouping Values into Multiple Categories

Hi all,

 

I'm running into issues when trying to group values into multiple categories. Example below. Smith Corp should be included in two different categories.

 

CompanyCategory
Smith CorpGeneral
Smith CorpBusiness
Johnson IncGeneral
Jane CoBusiness

 

Ultimately, I would want a Category slicer and a Company slicer. The Category slicer would filter the Company slicer. This would allow the user to look at the Category as a whole or drill down to a specific advertiser within that Category.

 

Because this isn't a one-to-one relationship or one-to-many relationship with my fact table, I created a mapping table and a bridge table to reduce ambiguity. However, when I add the Category into a slicer, it doesn't filter anything.

 

I'm not sure if this is how Power BI operates or if I'm missing something in my setup. Any advice would be greatly appreciated!

 

Test Dashboard on Google Drive

1 ACCEPTED SOLUTION

If you use many-to-many, bridge table isn't necessary. Ensure that the relationship is single direction. 

danextian_0-1752719882944.png

 





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

View solution in original post

4 REPLIES 4
danextian
Super User
Super User

Hi @hoyt22 

You category slicer isn't working because the relationship flows from advertiser bridge to advertiser group mapping only. You can change the relationship to bi-directional to make it work. But for simplicity's sake, I'll use a many-to-many single direction relationship between advertiser group mapping and competitor spend. Test in DAX studio which one is more optimize for your use case.





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

Thanks, @danextian.

 

So, do I not need the bridge table at all? And for the mapping, does it have to be a many to many relationship or would a one to many work? I'll definitely test it, but I'm trying to work out the logic.

 

I appreciate your help!

If you use many-to-many, bridge table isn't necessary. Ensure that the relationship is single direction. 

danextian_0-1752719882944.png

 





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

@danextian Thank you! Your solution worked. I've always been wary of many to many relationships, but it seems like it should be fairly straightforward in my case and not result in any issues.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors