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 folks,
what is actually the difference between slicer and the filters (Filters section on the right side)? When should I use slicer and when a filter? So far I have always used slicers, but they start to take too much space on the canvas..
Solved! Go to Solution.
Hey,
If you have an active Connection between 2 Visuals (select Slicer --> Format-->Edit Interactions)
and filter i.e. a table, you can see that the slicer puts an "Visual Level Filter" to that target visual.
So a Filter is a Filter with different scopes,
A Slicer: Visualisation of a Filter.
Its mainly used to provide an easier and more convenient way to the end user to filter the visuals.
I use them to provide the end user an intuitive way to filter the "Main" Categories, i.e. Customer Types or similar.
Greetings
Hey,
If you have an active Connection between 2 Visuals (select Slicer --> Format-->Edit Interactions)
and filter i.e. a table, you can see that the slicer puts an "Visual Level Filter" to that target visual.
So a Filter is a Filter with different scopes,
A Slicer: Visualisation of a Filter.
Its mainly used to provide an easier and more convenient way to the end user to filter the visuals.
I use them to provide the end user an intuitive way to filter the "Main" Categories, i.e. Customer Types or similar.
Greetings
A great article from DataVeld considering slicers in light of Power BI's new Filter Pane experience:
https://dataveld.com/2019/01/18/are-power-bi-slicers-still-relevant-with-the-new-filter-pane/
I enjoyed slicers for quite some time and created fancy selective interactions with other visuals and fancy selective synchronizations across the report pages. However, this made the reports more difficult to consume for the end users, since they can't easily see what's going on behind the curtain. So with the arrival of the new filter pane I decided to abandon slicers from my reports. This might seem less user-friendly on first sight. But since my customers are getting more and more used to the PowerBI UI anyway, it's a huge gain in report transparency.
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 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |