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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
106 | |
88 | |
74 | |
69 |
User | Count |
---|---|
123 | |
112 | |
95 | |
83 | |
73 |