2 Stacked 100% Chart

[RK_JOB]

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

[Anonymous]

hi @RK_JOB 

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

[v-stephen-msft]

Hi @RK_JOB ,

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.

[RK_JOB]

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

[mahoneypat]

That chart could be built with the Charticulator Visual.

(15) Austin Power BI User Group - Charticulator 101 - YouTube

Pat

[RK_JOB]

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

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

[RK_JOB]

@mahoneypat Can you please send me the template? 

I am attaching the sample data to get an idea and attached the output that I am looking for as well.

https://docs.google.com/spreadsheets/d/1aTT9wn-hfHRQAubZGFWmdi6HXz-3n4Kl/edit?usp=sharing&ouid=11439...

Thanks for your help,

RK

[mahoneypat · Accepted solution]

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

[RK_JOB]

@mahoneypat Can I ask for 1 more favor. How do I create little space between those 2 graphs? Just a little bit of line separating both the bars.

Thanks again!

RK

[mahoneypat]

You can do that in the Deneb visuals with paddingInner and paddingOuter. For example, on the Fold version of Deneb, you can add this syntax to the "xOffset" part.

"xOffset": {
"field": "key",
"sort": [
"Pct of Total",
"Pct of Bonus"
],
"scale": {
"paddingInner": 0.05,
"paddingOuter": 0
}
},

If you went with the Charticulator version, I believe it would require adding another Guide between the bars (but I would use the Deneb one for this use case).

Pat

[RK_JOB]

Thanks @mahoneypat I figured it out in Charticulator by increasing the Line Width.

I will learn Deneb next. Thanks for all of your help!!!

[RK_JOB]

@mahoneypat That's pretty good. What's the best way to re-produce it? Is there any way to copy paste the final graph?

If I have to do it from scratch then I am trying to follow the steps:

1. I created all the measures.

2. Started with Mark on the glyph.

3. Added Shape 1, looked at the attributes, put in text. Copied the attributes and then I got lost....lol

4. I believe I need to add Shapes.

Anyways, can 

If the graph is not copy-able then can you tell me broad strokes like - 

Step 1 : Get Mark

Step 2: Get guides figure it out

Step 3: Put text...something like that?

so I can try to figure out myself?

But thanks a lot, as always. You have always been a life saver. Only this Charticulator or deneb pieces require more learning and not very straightforward. 🙂

I haven't checked the Deneb piece yet but will eventually be learning that.

Thanks,

RK

[mahoneypat]

I would recommend going with one of the Deneb ones, but, either way, once you install the visual from AppSource (... Get More Visuals), you can copy the chart from my pbix to yours. You can then delete the fields from it and replace with your own. With Charticulator, you should get prompted to "map" your fields to the elements I created. For Deneb, you'll need to go through the Json in the editor and replace the field names with the ones you've added.

Pat