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
JaredK
Kudo Collector
Kudo Collector

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

 

Jared Knutzen | Visualization Consultant
Decisive Data | www.decisivedata.net

View solution in original post

2 REPLIES 2
JaredK
Kudo Collector
Kudo Collector

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

 

Jared Knutzen | Visualization Consultant
Decisive Data | www.decisivedata.net

View solution in original post

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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.