Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

2 Stacked 100% Chart

Hi,

 

Is it possible to create 2 100% Stacked Chart side by side? I tried to use the default 100% stacked chart but it won't let me bring the 2nd values. So I am looking for something like this:

 



 

But in the values I can only have 1 measure.

 

I need 1 more bar next to each existing bar.

 

 

Thanks in advance,

RK

 

Need Help
  • mahoneypat's avatar
    mahoneypat
    4 years ago

    Thanks for providing the data. This turned out to be more difficult than I initially thought. I built in one way with Charticulator and two ways with Deneb. I had to learn a few new things for the Deneb ones, so it was time well spent (and good content for an upcoming video). Below are two screen shots, and attached in the pbix file so you can get the code (if you like one of the version). They all could use some more formatting, but the harder parts are done.

     

    Charticulator

     

    Deneb (approaches with "fold" and "repeat"/"layer" look the same)

     

    Pat

13 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      mahoneypat I will check it out. Looks like there will be a learning curve for that. So nothing which is readymade...right?Do you think any custom visual can do the trick? I tried on Appsource but couldn't find any.

       

      Thanks for your help,

      RK

      • mahoneypat's avatar
        mahoneypat
        Microsoft Employee
        4 years ago

        Not aware of an existing visual. However, this would be straight forward to make with the Charticulator or the Deneb visual. Both have some learning curve, but neither are steep. If you get stuck, @ mention me and I can provide a "template" or "spec", respectively, you can import.

         

        Pat

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    What about clustered column chart?

     

    Best Regards,

    Stephen Tao

     

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      No, they want 100% stacked chart, side by side. Any other idea?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    hi Anonymous 

     

    Here, is a 100 % Stacked Clustered Column Chart where you can put two different values (e.g: Current year sales and Previous year sales) and can easily compare between them based on their category.

     

    100 % Stacked Clustered Column Chart. pbivizedit.com

     

    Download link for the custom visual file on this page,

    https://pbivizedit.com/gallery/100stacked-clustered-column-chart 

     

    This was made with our Custom Visual creator tool PBIVizEdit.com. With this tool,

    • anyone, irrespective of technical skills, can create their visuals
    • 15 minutes to create a visual from scratch
    • opens up many additional attributes to edit (e.g. labels, tooltips, legends position, etc)

    Give this a shot and let us know if you face any problems/errors.
    You can use the editor to modify your visual further (some modifications cannot be done in the Power BI window and have to be in the editor).

     

    Thanks,
    Team PBIVizEdit