Forum Discussion

bjw210's avatar
bjw210
Frequent Visitor
3 years ago
Solved

Chart YTD for multiple years from monthly data

I have a data set with monthly sales data that I'm trying to chart in a YTD view. If I have only one "scenario" a year I can use the year in the legend and it would work perfectly. However, I have mu...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    It looks like the limitation in a line chart is that one cannot drag more than 1 measure to Y-axis.  Therefore, i have used the Line and Clustered column chart.  Can you live this with?

    You may download the PBI file from here.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

Based on that data that you have shared, please show the expected result in a Table format.

bjw210's avatar
bjw210
Frequent Visitor
3 years ago

Below is the expected Chart which would have all 3 scenarios on it. 2022 Actuals, 2022 Budget, and 2021 Actuals. I can only seem to get one year of scenarios to show up on the chart at one time.

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    Hi,

    It looks like the limitation in a line chart is that one cannot drag more than 1 measure to Y-axis.  Therefore, i have used the Line and Clustered column chart.  Can you live this with?

    You may download the PBI file from here.

    Hope this helps.

    • bjw210's avatar
      bjw210
      Frequent Visitor
      3 years ago

      Hi Ashish, this looks nice but unfortunately won't work for my situation. 


      Thanks