Forum Discussion

HadasSpier's avatar
HadasSpier
Helper 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 dat...
Need Help
  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    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.

v-zhenbw-msft's avatar
v-zhenbw-msft
Community 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.

  • HadasSpier's avatar
    HadasSpier
    Helper I
    5 years ago

    Thank you!!