Forum Discussion
Creating Graphs showing data across years/months
Hi there,
I'm quite new to Power BI, so I hope someone can help me out.
I want a graph showing our sales in a "sales season", which for us is from September 1st to August 31st in a given year.
When I plot the data in a graph it will always show from January - December, and it will mix together data from different years.
I would like the months arranged in the correct order chronologically from September - August
Is there any workaround to this?
eddiep , Create a month sort order, and use that sort column for your month column
month Sort= if(Month([Date]) < 9, Month([Date]) +4 , Month([Date]) -8 )
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
1 Reply
eddiep , Create a month sort order, and use that sort column for your month column
month Sort= if(Month([Date]) < 9, Month([Date]) +4 , Month([Date]) -8 )
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c