Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to Solution.
Oh my goodness this worked so well! Thankyou so very much! What a handy tip!
Oh my goodness this worked so well! Thankyou so very much! What a handy tip!
@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
User | Count |
---|---|
85 | |
74 | |
71 | |
68 | |
56 |
User | Count |
---|---|
96 | |
94 | |
92 | |
78 | |
71 |