Forum Discussion
sorting on multiple years data
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.
6 Replies
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 ...
Hi Anonymous
Please kindly share your simple worksheet/dummy pbix preferred.
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
Hi,
To the x-axis of your visual, drag 2 columns - Year and Month.
