Skip to main content
Microsoft Idea

Power BI

Completed

Change order of filters in filter pane

Vote (336) Share
's profile image

on 20 Nov 2018 06:47:08

I love the new filter experience, much better. It would be great if the filters in the filter pane could be ordered by the author.
At times there are filters that have a natural hierarchy (Region/Plant; Manager/Employee) and presenting them in the wrong sequence causes the users to become confused.

Comments (13)
's profile image Profile Picture

Caesar on 06 Jul 2020 00:07:23

RE: Change order of filters in filter pane

This feature has already been added. You can drag and drop the Filters to the order you want..

's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:49:07

RE: Change order of filters in filter pane

Ben Sanders this is now available (May update) and works for me. What is not there yet is the ability to "Edit interactions" through the new filter pane. Please vote for this idea here;

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/36013585-allow-edit-interactions-for-filters-pane-or-add

's profile image Profile Picture

Ben Sanders on 05 Jul 2020 23:49:07

RE: Change order of filters in filter pane

I should point out that the documentation says that custom sort is available...

https://docs.microsoft.com/en-us/power-bi/power-bi-report-filter-preview#sort-the-filter-pane

So when are we actually going to get the functionality?

's profile image Profile Picture

Didier Terrien on 05 Jul 2020 23:48:16

RE: Change order of filters in filter pane

Voted. Filters are so important that the developper needs a total control on the filter pane. The ideas about the filter pane will have no end.
Personaly, I would like to have a more flexible solution with the possibility to add the slicers I want including custom visuals. So I developped my own solution.

Please have a look at this one minute video and share your comments there :

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

's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:47:54

RE: Change order of filters in filter pane

Please, add this feature, thanks !

's profile image Profile Picture

Karim ABDELOUAHAD on 05 Jul 2020 23:47:35

RE: Change order of filters in filter pane

Why still not been added yet?

's profile image Profile Picture

BIM_David on 05 Jul 2020 23:47:35

RE: Change order of filters in filter pane

While i'd still like to be able to order them as I wish and bucket filter in categories, for now there is a workaround that was released in the past few weeks allowing to rename filters. By numbering them you can start creating an order in the way the filters will be displayed.

's profile image Profile Picture

Guido on 05 Jul 2020 23:46:45

RE: Change order of filters in filter pane

Yes, we need to sort the order of the filters by ourselfs. Please change this.

's profile image Profile Picture

Vicky M on 05 Jul 2020 23:41:28

RE: Change order of filters in filter pane

yes, need this... this was a surprise that filters lose the order and default to alphabetical...

's profile image Profile Picture

Dhruvil shah on 05 Jul 2020 23:41:21

RE: Change order of filters in filter pane

I also agree that the new filter experience is really useful and more user friendly than the slicers.
I would like to suggest one more improvement in addition to above mentioned ideas.
Which is grouping of the filters. in some cases, list of filter is quite long. it would be helpful if the grouping feature is also provided so the related filters can be grouped.
E.g. Group name: "Time Filters" and under that can be fields such as "Date", "Month", "Year", "Week" etc.