sorting on multiple years data

[Anonymous]

Hi All,

I've calendar which contains the mulitple years of infomation and i have liked this calendar to transaction table.

But i couldn't sort it by y year-month. Attached the screenshot for your reference.

Thank you.

[Ashish_Mathur]

Hi,

To the x-axis of your visual, drag 2 columns - Year and Month.

[v-diye-msft]

Hi @Anonymous 

Do you mean you'd like to set the month sorting from 2019/01-2019/12 in order?

please kindly refer to this post:

https://community.powerbi.com/t5/Desktop/Month-sort-for-multiple-years-data/m-p/345504

[amitchandak]

Create following for the month

sort month = format(date[date],"YYYYMM")

Then in Model view, mark this as sort column for the month-Year column. In graph sort using sort option under ... 

[Anonymous]

Hi, I am getting below error while sorting based on the sort column.

[v-diye-msft]

Hi @Anonymous 

Please kindly share your simple worksheet/dummy pbix preferred.

[Anonymous]

Hi, I am able to fix the issue. Thanks