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.
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.....
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |