Forum Discussion
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)
Hi wynhopkins,
Please make sure you are clicking below highlight button to sort year:
Best Regards,
Qiuyun Yu
8 Replies
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 YuAll reports, starting with a blank file and a simple single column data table
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.
Hi wynhopkins,
Please make sure you are clicking below highlight button to sort year:
Best Regards,
Qiuyun YuThanks, 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.
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 Yuyes thanks
Hi wynhopkins,
Thank you for your update. I will close this thread. :smileyhappy:
Best Regards,
Qiuyun Yu
