Monthly chart with multiple years

[Anonymous]

Hi,

I'm trying to create a monthly chart and my data set contains data from Nov 2018 - Feb 2019.
How can I order my chart chronologically and not the way power bi displays the data below? Thanks in advance.

[Anonymous]

Hi

You can sort the column in your data by another column.

Therefore, if you create a period of YYYYMM, you can the sort by this and it will display as you wish.

Please see below some code to create a period of this type.

Period = FORMAT(YEAR(date), "####") & FORMAT(MONTH(date), "0#")

Please see sort by instructions instructions below:

• Select column to sort
• Select "Modelling" tab in your ribbon
• Select "Sort by Column"
• Select column you wish to sort by.

Good luck!