Forum Discussion

RobFlanders's avatar
RobFlanders
Frequent Visitor
9 years ago
Solved

Multi-Year Timeline

I am looking to present a sequence of data points each attached to a date. I am looking to group them by month and present them in date order. The dates start in May last year and end in June this ye...
Need Help
  • robofski's avatar
    robofski
    9 years ago

    RobFlandersWhen you remove the year from the Date you are now asking to only see things in Month buckets so data from every Month of January will be groupd, every February etc, so in your case the values from May of 16 and May of 17 will be combined together in the 'May' data point.

    If you stick with the Line chart with Year and Month levels selected and then use the Drill Down arrow you can go to the next level down.  Be sure you use the correct Drill Down option!!!

fhill's avatar
fhill
Resident Rockstar
9 years ago

Try this...   We have 'Month' as it's own column in our raw data as text labeled '01-Jan', '02-Jan', etc  (you can easy get Power BI to create this with copyign and splitting your data and using mass transforms.)  We then graph our data by (text) Month and use Year from our real formatted Date column as the legend.  Values is Price (or whatever you want to graph up and down).

 

P.S.  You only have 2 years right now, so colors aren't critical, but see below where we 'fade' from old to current then go alternative colrs for future.

 

Hope this helps,

Forrest