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

Horizontal List Slicer - sort does not work

I use Year in a slicer, change it to the List style and then choose formatting General > Horizontal.

 

My Year is then autosorted descending, which is not what I want - I want years to increase from left to right.

 

The problem is I cannot re-sort while in Horizontal layout.   I have to go back to Vertical layout,  sort, then go back to horizontal.

 

Version: 2.57.5068.721 64-bit (April 2018)

1 ACCEPTED SOLUTION
v-qiuyu-msft
Community Support
Community Support

Hi @wynhopkins,

 

Please make sure you are clicking below highlight button to sort year: 

q6.PNG

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

8 REPLIES 8
v-qiuyu-msft
Community Support
Community Support

Hi @wynhopkins,

 

Thank you for your update. I will close this thread. Smiley Happy

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

yes thanks

v-qiuyu-msft
Community Support
Community Support

Hi @wynhopkins,

 

The highlight button is used for sort A-Z or Z-A. Just click on the column name will not change sort order. 

 

So the issue is solved now, right? 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks, yes that's it.   Could that option be made clearer?     It's not obvious that there are 2 separate things to click on

 

I thought it used to work just by clicking on the word but I could be wrong.

v-qiuyu-msft
Community Support
Community Support

Hi @wynhopkins,

 

Please make sure you are clicking below highlight button to sort year: 

q6.PNG

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

interestingly @v-qiuyu-msft I notice your years are not consecutive,  you are missing 2006.  

 

My slicer also sorts if I miss a year out.

All reports,  starting with a blank file and a simple single column data table

 

Year Slicer Not Sorting.gif

v-qiuyu-msft
Community Support
Community Support

Hi @wynhopkins,

 

I'm not able to reproduce the issue on my side. Would you please check if the issue happen to one specific report or all reports? How about restart the Power BI desktop then test again? 

 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.