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 
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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    As per my knowledge Power BI doesn't allow multiple values if you don't put values in the axis and if you put the only legend it will allow one value only.
    You may try custom visual "Multiple Axis Chart - xViz"

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Community Support
    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