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.
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?
Solved! Go to Solution.
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/32918...
According 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/33091...
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/32918...
According 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/33091...
Hello All,
Any suggestions or ideas?
Maybe someone found some workaround?
Our developers have experienced the same thing. @Admin lease advise on when we will have the ability to custom sort filters in filters pane.
Thank you for posting. I am having the same issue after this latest Power BI Desktop update.
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 |
---|---|
111 | |
107 | |
88 | |
76 | |
67 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |