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
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
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.