The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.....
Solved! Go to Solution.
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)
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)
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.....