Forum Discussion
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).
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}})
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.
Please help
- Anonymous3 years ago
Oh my goodness this worked so well! Thankyou so very much! What a handy tip!
2 Replies
- amitchandak
Super User
Anonymous , 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
- AnonymousNot applicable
Oh my goodness this worked so well! Thankyou so very much! What a handy tip!