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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Sara16
Helper III
Helper III

Modelling Issue - Tables Created for Filters not connecting

Hi Power BI

 

I have an issue with my slicers for my visuals.

 

For my dashboard to work correctly (and relationships to work) I had to build three slicer tables (Division, Branch, Section).

Sara16_0-1674167668246.png

 

However when I diddone this, my slicers wont connect between eachother. For example, when a Division is selected from a slicer, I should only be able to see the Branches and Sections that connect to that Division.  

 

Example of Table built for filters

= Table.Group(#"Promoted Headers", {"Branch"}, {{"Count", each Table.RowCount(_), Int64.Type}})

Sara16_0-1674093514816.png

 

When I try to fix the relationship I recieve the following error. I cant remove the connections between my other tables as I had to set this up initially for everything to work in the first place. 

 

Sara16_1-1674167750885.png

 

Please help

 

 

1 ACCEPTED SOLUTION
Sara16
Helper III
Helper III

Oh my goodness this worked so well! Thankyou so very much! What a handy tip!

 

View solution in original post

2 REPLIES 2
Sara16
Helper III
Helper III

Oh my goodness this worked so well! Thankyou so very much! What a handy tip!

 

amitchandak
Super User
Super User

@Sara16 , if they are from same table they will filter each other, else you have to try one of the two ways

 

https://www.youtube.com/watch?v=cyOquvfhzNM

 

How to filter the slicer of a disconnected table: https://youtu.be/cV5WfaQt6C8

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors