Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
Hi All, I need help on making these 2 tables using the same slicer. I'm using direct query method.
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 🙂
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
User | Count |
---|---|
120 | |
65 | |
62 | |
56 | |
50 |
User | Count |
---|---|
181 | |
85 | |
67 | |
62 | |
55 |