Forum Discussion

kitala11's avatar
kitala11
Icon for Helper III rankHelper III
5 years ago
Solved

Visualisation with charts

Dear all,   How can I make it such that I am using stacked bar chart but I want it to be combined in 1 graph like the one below? I can only manage to find one sort of visualization like that in Pow...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi kitala11 ,

     

    I suggest you transform your table to the following format(unpivot the last three columns):

     

    Then it will act like what you want:

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

     

    Best Regards,

    Dedmon Dai

     

kitala11's avatar
kitala11
Icon for Helper III rankHelper III
5 years ago

I am adding them into values. However, I need to proj aprov to be in the legend for the stacked columns. The thing is if i have something in the legend. The values can only contain 1 (measure/column). Which is shown as the first top photo, that is how it looks like if I do it the way you are saying

kitala11's avatar
kitala11
Icon for Helper III rankHelper III
5 years ago


Here is a sample data, you can imagine it for a few more months, but that is what the data looks like, besides the numeric value being altered by me.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello kitala11 
    Can you please provide in table format instead of image?