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.
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)
Solved! Go to Solution.
Hi @wynhopkins,
Please make sure you are clicking below highlight button to sort year:
Best Regards,
Qiuyun Yu
Hi @wynhopkins,
Thank you for your update. I will close this thread.
Best Regards,
Qiuyun Yu
yes thanks
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
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.
Hi @wynhopkins,
Please make sure you are clicking below highlight button to sort year:
Best Regards,
Qiuyun Yu
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
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
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 |
---|---|
114 | |
100 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |