Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Monthly chart with multiple years

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.

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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!