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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
sherlycheng
Frequent Visitor

Power BI Desktop Many to Many Relationships on slicer Month & Year

Hi All, I need help on making these 2 tables using the same slicer. I'm using direct query method.

Capture.PNG

 

Mark Number 1. 

Data comes from tableComplaint it has Month and Year column

 

 

Mark Number 2. 

Data comes from tableComplaintRate it has Month and Year column

 

How can I create a slicer Month & Year to unite those two tables? 

 

Thank you 🙂 

1 REPLY 1
v-shex-msft
Community Support
Community Support

HI @sherlycheng,

 

Actually, if your tables not direct linked with date column, I'd like to suggest you create bridge calendar to link date columns from different tables.  Then use bridge date as source of slicer to filter on two side tables.

 

BTW, if your tables not use date column as key to create relationship and use date column from one of these tables as source of slicer. Filter effect will direct apply on source table and use related records to filter other table.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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