Skip to main content
Microsoft Idea

Power BI

Completed

Active Filter Indication

Vote (45) Share
Sanjay Shah, Pune, India's profile image

Sanjay Shah, Pune, India on 29 Sep 2016 12:28:59

A filter can be applied to a Report via a tile, via a slicer or via filters. However it is very difficult for the user to know whether a filter has been applied. There should be an indicator on the report identifying that a filter has been applied. On clicking that indicator, one should get a list of all the filters applied on the report with the ability to deselect filters as required.

Administrator on 21 Nov 2018 05:58:15

Part of November release as preview! From visual header, one can hover / click on the filter icon to see filters/slicers applied to that visual.

Comments (6)
Sanjay Shah, Pune, India's profile image Profile Picture

Didier Terrien on 05 Jul 2020 23:48:15

RE: Active Filter Indication

I consider the user experience is still not the best. I would like to have the 'indicator' mentionned in the idea and a more flexible solution with the possibility to add the slicers I want. So I developped my own solution.

Please have a look at this one minute video :

https://thebipower.fr/index.php/2019/02/01/add-a-filter-page-to-your-report/

Sanjay Shah, Pune, India's profile image Profile Picture

edh on 05 Jul 2020 23:35:13

RE: Active Filter Indication

Agreed. It would be very helpful if for the FILTER icon in a visual to have some sort of visual indicator that that visual is being filtered, sliced, or cross-filtered.

Sanjay Shah, Pune, India's profile image Profile Picture

Power BI User on 05 Jul 2020 23:18:17

RE: Active Filter Indication

Really important one from user experience point of view.

Sanjay Shah, Pune, India's profile image Profile Picture

Mike Donnellan on 05 Jul 2020 23:01:27

RE: Active Filter Indication

Many ideas/suggestions here are related to this one. Users need to be able to see the filters that are currently applied to their data.

Sanjay Shah, Pune, India's profile image Profile Picture

Tibor Szentgyorgyi on 05 Jul 2020 22:36:02

RE: Active Filter Indication

There could also be useful a "Clear all filters" button as well, and perhaps a "Restore default filter level" too, that would change filters to their status from the last saved file version.

Sanjay Shah, Pune, India's profile image Profile Picture

Vincent CHUFFART on 05 Jul 2020 22:32:04

RE: Active Filter Indication

ACTIVE FILTERS AS A VISUALISATION OBJECT

This active filter indication / description could populate a special tile/visualisation element, so as to be placed, and formatted according to the need.
Better solution than a fixed footer or place on the page.