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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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