Forum Discussion

kitala11's avatar
kitala11
Helper 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

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello kitala11 
If forecasts are the measures then you can add them into the values.
Try and check or you can provide the sample data after removing sensitive data.

  • kitala11's avatar
    kitala11
    Helper 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
      Helper 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?

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hello kitala11 
      You can use thevcustom visual "Ultimate Stacked Free 4.2.0"

      • kitala11's avatar
        kitala11
        Helper III
        5 years ago

        that is exactly what I have.... which i mentioned that i am looking for other options because it is not presentable