Forum Discussion
Custom sort functionality in the Filters pane
Hello,
Custom sort functionality in the Filters pane doesn't work after updating Power BI to the latest version(2.118.621.0).
When I try on the Filter pane to drag and drop filters to change alphabetical order - changes are not applied.
Filters are sorted only A-Z or Z-A.
Although, filters that were custom sorted before the version update(in the previous version) - display custom order.
According to documentation - custom sort functionality is available in the Filters pane.
When creating a report, you can drag and drop filters to rearrange them in any order.
Could you please help with this? Maybe I missed some new configuration options after the update?
My recommendation for how to deal with this issue:
1. Wait for the July update - looks like the issue should be fixed there;
2. Downgrade to the May version;
3. Add a prefix to the name of the filter(like [1 filter name], [2 filter name]) and sort alphabetically - not elegant but simple;
4. Use my workaround:
- step 1: select your visual and open the filter pane;
- step 2: rename your filter item(add number prefix) and sort alphabetically;
- step 3: try changing sorting by drag and drop - you don't get any result, but only change sorting to custom;
- step 4: rename your filter item back and save your result;
Link to the registered issue - https://community.fabric.microsoft.com/t5/Issues/Reorder-fields-in-filter-pane-is-broken/idi-p/3291862According to v-yanjiang-msft response:
The fix is checked in and will be in the SU07 release.Original answer: https://community.fabric.microsoft.com/t5/Issues/Reorder-fields-in-filter-pane-is-broken/idc-p/3309182/highlight/true#M96973
4 Replies
My recommendation for how to deal with this issue:
1. Wait for the July update - looks like the issue should be fixed there;
2. Downgrade to the May version;
3. Add a prefix to the name of the filter(like [1 filter name], [2 filter name]) and sort alphabetically - not elegant but simple;
4. Use my workaround:
- step 1: select your visual and open the filter pane;
- step 2: rename your filter item(add number prefix) and sort alphabetically;
- step 3: try changing sorting by drag and drop - you don't get any result, but only change sorting to custom;
- step 4: rename your filter item back and save your result;
Link to the registered issue - https://community.fabric.microsoft.com/t5/Issues/Reorder-fields-in-filter-pane-is-broken/idi-p/3291862According to v-yanjiang-msft response:
The fix is checked in and will be in the SU07 release.Original answer: https://community.fabric.microsoft.com/t5/Issues/Reorder-fields-in-filter-pane-is-broken/idc-p/3309182/highlight/true#M96973
Thank you for posting. I am having the same issue after this latest Power BI Desktop update.
Our developers have experienced the same thing. Member123456 lease advise on when we will have the ability to custom sort filters in filters pane.
Hello All,
Any suggestions or ideas?
Maybe someone found some workaround?
