cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ray1017 New Member
New Member

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.

 

pbi.PNG

1 REPLY 1
bwsutton1990 Frequent Visitor
Frequent Visitor

Re: Monthly chart with multiple years

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!