cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CahabaData
Memorable Member
Memorable Member

Slicer sort

Slicer is list of Dates, 1 per month:

1/1/2012

2/1/2012

etc.

 

This list comes from the table data itself as this is what is stored in the data.

 

All I seek is to reverse the sort so it is descending - which would put the most recent months at top.

 

One Q&A suggested resorting the table itself, which I did, but that has not affected the order in this slicer.  Just want to check that this feature does not indeed exist - have looked around the interface and cannot find - but I could be wrong.

 

I have the same issue, conceptually, with the Matrix visual - whereby date columns are ordered ascending and there is no way to reverse the column order.  Viewers are interested to have older data available but the most current data is of greater interest - so having to scroll to find the newest data is less convenient.

 

Without having to set up a custom work-around of a sort column; If PBI is to default - I think most would want it to descend (when it comes to dates) so the that the most current is what is first...and the ability to reverse the sort of the slicer or matrix columns as a feature, if indeed such a feature does not exist.....

www.CahabaData.com
1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @CahabaData, if you click on the slicer and select the "..." in the top right hand corner, there should be a sorting option. You can select that to reverse the order of the sort (it will change from A>Z to Z>A)

 

SlicerSort.PNG

 

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi @CahabaData, if you click on the slicer and select the "..." in the top right hand corner, there should be a sorting option. You can select that to reverse the order of the sort (it will change from A>Z to Z>A)

 

SlicerSort.PNG

 

I looked at the [...] area it did not show A-Z or Z-A ...it just stated 'Sort by Date' ...so I didn't bother to press it....cause it was already sorted by Date..... my mistake .....

 

as when I pressed it then it reversed sort and then displayed the Z-A......

 

was thrown off by no initial Z-A indicator.....

 

 

 

 

 

 

www.CahabaData.com

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.