Column sort order using month and Year

[Anonymous]

Hi,

Can someone please guide me on how to sort a Matrix visual by month_year (Date field) sorted descending.

[amitchandak · Accepted solution]

@Anonymous ,

Have column like this in you date table

Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")

Make Month Year sort  as you sort column and you can use three dots on visual to sort asc or Desc

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

If you are looking it for a Matrix column where there is no option to sort. Use the below on as your sort column

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

[Pragati11]

Hi @Anonymous ,

Can't help much until you share some screenshots here. But follow following article on sorting columns in Matrix:

https://www.biinsight.com/quick-tips-how-to-sort-matrix-by-column-in-descending-order/

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

[Anonymous]

@Pragati11

Thank you for your response and link.

Yes, that's what i 'm stuck on.

@amitchandak 

Thank you for your answers,

I tried your solution but didnt work for me.

Is there any way i can attach a mockup PBI file over here,?

[amitchandak]

@Anonymous , refer to the attached file after signature check page 3.  You can upload on dropbox or one drive and share the link.

[Pragati11]

Hi @Anonymous ,

Just want to understand what you are stuck on.

You can use Weshare to share your pbix or dropbox.

Thanks,

Pragati

[Anonymous]

It's working as desired. Tqvm