Forum Discussion

HadasSpier's avatar
HadasSpier
Icon for Helper I rankHelper I
5 years ago
Solved

Create waterfall chart or timeline chart with data for each month in different column

Hello,

 

I want to create a timeline/waterfall chart.
I have a column for each month.
I need to display the changes throughout the months for each student (only for his name).

example for my data:

 

 

 

Thanks!

 

 
 

 

 
 
 
 
 
 
 
 
 

 

Need Help

4 Replies

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion
    5 years ago
    you need to pivot your date into one column. Best to provide your data in a text format.
    • HadasSpier's avatar
      HadasSpier
      Icon for Helper I rankHelper I
      5 years ago

      Hi!

      I tried to create one, but I did not succeed to create a good one in power bi only.
      I want to save the values and the name of the month so I could use it for the timeline chart

      Thank you for your help!

  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi HadasSpier ,

     

    In Power Query Editor, you need to select grade, class and name column. Then click the Unpivot other columns.

     

     

    But we found there is Q1 2020 in your month column, do you want to delete it or stay it?

    Could you please show the exact expected result based on the table that you have shared?

     

    Best regards,

     

    Community Support Team _ zhenbw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    BTW, pbix as attached.