cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HugoJesus
Helper III
Helper III

Filter Pane Sort Values Inside

Hi everyone, 

 

I will be more objetive as possible, before create this message, I saw many Messages from other persons, but I've never found something like this.

 

Someone of my team, asked me to sort downward the values in the Filter Pane, this is different from sort the filters. 

 

Regards,

Hugo Jesus

1 ACCEPTED SOLUTION

Hi @HugoJesus

 

Create 3 calculated columns as below:

 

Year = YEAR('Table'[Date])
Rank = RANKX(SUMMARIZE('Table','Table'[Year]),'Table'[Year],,DESC)
_Year = 'Table'[Year]

 

Finally select column _year,go to menu bar>column tools>sort by:rank  :

Annotation 2020-06-01 171458.png

Then put the new column _Year in the filter pane and you will see:

Annotation 2020-06-01 171912.png

For the related .pbix file,pls click here.

 

 
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!

View solution in original post

6 REPLIES 6
amitchandak
Super User
Super User

@HugoJesus , you can create desc rank on year and mark that a sort column. then it will sort desc.

 

Year Rank = RANKX(ALL('Date'),'Date'[Year],,DESC,Dense)

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

 

Refer this file for the example of the month year desc sort on matrix column

https://www.dropbox.com/s/94zxohjgoaan28e/DescMonthSort.pbix?dl=0

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

Wonderful solution, thanks a lot Super User IV !

The solution you have presented ( 

Refer this file for the example of the month year desc sort on matrix column

https://www.dropbox.com/s/94zxohjgoaan28e/DescMonthSort.pbix?dl=0  ) is not working.

 

Still have the same issue, the dates in the Filter Pane for "Filters on this page" are upward and all i want is to have the values sorted downward.

 

If it's possible, you can send me the PBIX with the same example that i'm sending in the image below

 

image.png

 

 

 

HugoJesus
Helper III
Helper III

PowerBI Image 1.png

 

I want to sort Downward the filter tha is highlighted, instead of 2016 - 2020, change for 2020 - 2016, the most recent first.

 

This is possible to do ?

Hi @HugoJesus

 

Create 3 calculated columns as below:

 

Year = YEAR('Table'[Date])
Rank = RANKX(SUMMARIZE('Table','Table'[Year]),'Table'[Year],,DESC)
_Year = 'Table'[Year]

 

Finally select column _year,go to menu bar>column tools>sort by:rank  :

Annotation 2020-06-01 171458.png

Then put the new column _Year in the filter pane and you will see:

Annotation 2020-06-01 171912.png

For the related .pbix file,pls click here.

 

 
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!

View solution in original post

Hi Kelly,


I've did it like you said and "Voilá". Perfect, completely awesome, that's the idea.

 

I'll repeat to all reports that I've.

 

Thanks again,

 

Have a nice week. 🙂

 

Regards
Hugo Jesus

 

Below It's my example.

image.png

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!