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.
I have a report that I need to filter using 10 - 12 different criteria. In the past, we would allign all slicers in a column on the left side of the page, but as we reach the need to combine 10 - 12 different filtering criteria, the page is quickly becoming over crowded. Have you found any way to better handle the need to combine 10 - 12 different slicers in an elegent way?
Thanks!
Solved! Go to Solution.
Perhaps use Sync Slicers. So, have a page of just slicers. The on the actual report page, hide all of your sync'd slicers. Nice clean interface, more space for reports, etc.
This Video has a great example of how to make a slicer 'overlay' with a button.
https://www.youtube.com/watch?v=xy9nmSQeUWg
@Anonymous,
Honestly, the best approach is to decide if you really need 10-12 slicers on one page. Are they all always necessary?
Other options:
Base page:
The info button in the top right will bring up the overlay...
Overlay:
...which frosts over the visuals and contains the slicers. Any selections will be maintained when you close the overlay to view the report again.
That overlay page sounds really interesting, but I've never seen that before.
Is there anyway to make a true overlay page or are you just unhiding a rectangle with some slicers on it?
The overlay isn't an actual feature, it's just a bookmark trick doing what you said. Have a base page bookmark, then an overlay bookmark (shaded shape, slicers), then a reset bookmark.
It looks cool to clients and allows the use of a lot of slicers (I've also had an overlay that contains tooltips/visual explanations, basically using it as a help page), but adds a layer of complexity. It's not economical for large reports.
The best option is probably a landing page with synced slicers, as Greg mentioned.
Perhaps use Sync Slicers. So, have a page of just slicers. The on the actual report page, hide all of your sync'd slicers. Nice clean interface, more space for reports, etc.
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |