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

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

Reply
RMRaptor
Frequent Visitor

Filter Detail table based on Master Table- Data slicer selection

Hello All 

Master-Detail table are connected by Employee Id key 

Master table  show list of all projects and employees , when employee is selected from master matrix table, detail matrix table gets filtered  for specific employee and show all projects that employee is working.  In Report page i have date slicer from master table which is filtered to show 2023 year projects, so how do i pass same date slicer filter selection to detail table .?

do i have to create second relationship on date column, in that case secon relationship will be optional not as primary , what  are options.?

Thanks

RM

 

Master-Details pbidesk.PNG

0 REPLIES 0

Helpful resources

Announcements
Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.