Forum Discussion

at8's avatar
at8
Frequent Visitor
3 years ago
Solved

How can i make a stacked column chart

Hi all, 

 

I have my data in this format. Each column with the numbers should be one bar of the stacked colum chart. In this case i need to have 4 bars on the stacked columns. The first column represents the legend that is required. For some reason i am able to plot only one colum. How can i solve this?

 

Thankyou

Need Help
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, at8 

     

    You can try the following methods. In the Power Query, choose first column-unpivot Other Columns:

    Result:

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

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

1 Reply

  • v-zhangti's avatar
    v-zhangti
    Community Support
    3 years ago

    Hi, at8 

     

    You can try the following methods. In the Power Query, choose first column-unpivot Other Columns:

    Result:

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

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