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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Pikachu-Power
Post Prodigy
Post Prodigy

Sort tiles in filter pane not possible

Hi all,

 

in Power BI Desktop (Version: 2.118.828.0 64-bit June 2023) it is not possible to sort the tiles in the filter pane.

 

Seems like a new bug.

 

Best regards

Pikachu-Power

 

 

1 ACCEPTED SOLUTION
anosul
Advocate I
Advocate I

9 REPLIES 9
Pikachu-Power
Post Prodigy
Post Prodigy

Hello @anosul 

Thanks for the informations. To avoid extra affort i would wait for the update. But maybe it will help others. Good that it is accepted now.

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

 

anosul
Advocate I
Advocate I

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

The issue with the custom sort functionality in the filters pane has been reproduced at least since the June 2023 update from version 2.118.621.0.

An update to latest 2.118.828.0 doesn't fix it.

 

I found a few related topics:

  1. Custom sort functionality in the Filters pane - https://community.fabric.microsoft.com/t5/Desktop/Custom-sort-functionality-in-the-Filters-pane/m-p/...
  2. Reorder fields in filter pane is broken - https://community.fabric.microsoft.com/t5/Issues/Reorder-fields-in-filter-pane-is-broken/idi-p/32918...

But overall, as I understand, a few members reported it internally, and we all look forward to updates.

bmacknz
Advocate I
Advocate I

Definetly an issue, I came here to find a solution for the same - need this fixed!

Pikachu-Power
Post Prodigy
Post Prodigy

Thanks i reported an issue. That was possible as long as i know the filter pane 🙂

Pikachu-Power
Post Prodigy
Post Prodigy

Hi @Ritaf1983

Sorry with sort i mean sort individually and not alphabetical:

 

2023-06-26 07_14_00-Window.png

 

Before this was always possible and makes sense to bring it in a logical sequence for the enduser.

 

I don't remember how it was (from 2017 working with the tool).
If it is something that critical just give indexes to the names for sorting:

Ritaf1983_0-1687757675231.png

if you suspect that it is a kind of bug, try to report it as an issue here:https://community.fabric.microsoft.com/t5/Issues/ct-p/PBI_Comm_Issues
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

 

Ritaf1983
Super User
Super User

Hi @Pikachu-Power 

I have the same version and tested it on my machine.
works perfectly...

Ritaf1983_0-1687656587174.png

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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