Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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
Anonymous
Not applicable

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!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.