Is there a simple way to get a column (field) sorted descending by default so that when it is used as a page level filter the highest value (in my example date) is shown at the top?
I could of course sort by another column that works as an reverse sort column but I would like to avoid this workaround.
Solved! Go to Solution.
I'm afraid in page level filter there's no such option. However, you can create a slicer and select Sort descending.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I'm afraid in page level filter there's no such option. However, you can create a slicer and select Sort descending.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I already considered this but unfortunately my report page contains too many different filters to put them into slicers without taking too much space on the page.
For now I solved it with conditional columns in the data model that just take the date/month/year value *-1 but it is not a very elegant solution. I hope that as the new filter pane is still in preview there will be more advanced configuration available in the future.
I hope that as the new filter pane is still in preview there will be more advanced configuration available in the future.
Actually new filter pane will have more features in the future. You can submit your idea here to help improve power bi.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!
User | Count |
---|---|
400 | |
107 | |
68 | |
56 | |
49 |
User | Count |
---|---|
371 | |
122 | |
79 | |
67 | |
57 |