Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
anosul
Advocate I
Advocate I

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?

1 ACCEPTED SOLUTION
anosul
Advocate I
Advocate I

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;

anosul_0-1688117518981.png

 


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...

View solution in original post

4 REPLIES 4
anosul
Advocate I
Advocate I

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;

anosul_0-1688117518981.png

 


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...

anosul
Advocate I
Advocate I

Hello All,
Any suggestions or ideas?
Maybe someone found some workaround?

heidibb
Helper IV
Helper IV

Our developers have experienced the same thing. @Admin lease advise on when we will have the ability to custom sort filters in filters pane.

stephanie_pena
Regular Visitor

Thank you for posting. I am having the same issue after this latest Power BI Desktop update.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.