Sort Month-Year column in Descending order in Matrix visual

[Anonymous]

Hi Everyone,

I have a "Month-Year" column with values from "Apr 2017" to "Mar 2019". When I put it in Matrix visual, it displayed data from "Apr 2017" to "Mar 2019" i.e. ascending order. So, I want to display data starts from "Mar 2019" to "Apr 2017" i.e. descending order.

Also, I've tried to sort the column in descending order from visual level option and Data View but it wasn't reflected on matrix visual.

 

Please help. 

Thanks

[v-lili6-msft · Accepted solution]

hi, @Anonymous 

You could use Sort by column in Power BI Desktop

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

Step1:

Add a sort conditional column for "Month-Year" column.

for example:

Condition = - ( YEAR('Date'[Date])*100+MONTH('Date'[Date]) )

Step2:

Then select "Month-Year" field and then click Modeling->Sort by column->"Condition"

Result:

Best Regards,

Lin

[Anonymous]

@v-lili6-msft  I really appreciate your support.