cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Pierre-Se Frequent Visitor
Frequent Visitor

Sort filter criteria in page level filter descending

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Sort filter criteria in page level filter descending

@Pierre-Se ,

 

I'm afraid in page level filter there's no such option. However, you can create a slicer and select Sort descending.

Capture.PNG 

 

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.

3 REPLIES 3
Community Support Team
Community Support Team

Re: Sort filter criteria in page level filter descending

@Pierre-Se ,

 

I'm afraid in page level filter there's no such option. However, you can create a slicer and select Sort descending.

Capture.PNG 

 

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.

Pierre-Se Frequent Visitor
Frequent Visitor

Re: Sort filter criteria in page level filter descending

@v-yuta-msft 

 

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.

Community Support Team
Community Support Team

Re: Sort filter criteria in page level filter descending

@Pierre-Se 

 


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.