Filter Pane Sort Values Inside

[HugoJesus]

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

[amitchandak]

@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

[malopez]

Wonderful solution, thanks a lot Super User IV !

[HugoJesus]

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

[HugoJesus]

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 ?

[v-kelly-msft · 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  :

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

For the related .pbix file,pls click here.

 
Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[HugoJesus]

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.