Combo clustered Bar chart with One bar subdivided into different categories?

[Anonymous]

Hello All,

Currently I have combo clustered bar chart in Power BI that looks like this. I recreated it in excel. Each bar catergory and line are measures against 2 tables that look like this. 

Stock= sumx(stock)

Desired = sumx(Desired)

Delta = stock - Desired

Month	Stock	Category
1	83	A
2	30	A
3	33	A
4	43	A
5	49	A
6	4	A
7	74	A
8	43	A
1	16	B
2	48	B
3	23	B
4	45	B
5	15	B
6	14	B
7	5	B
8	45	B

Month	Desired
1	100
2	100
3	100
4	100
5	100
6	100
7	100
8	100

Is there a way to customize the first column to show the breakdown of A and B but A and B are stacked? 

I think this may be impossible but I was wondering if there were other solutions out there or potentially other ways to visualize this.

[qqqqqwwwweeerrr · Accepted solution]

Hi @Anonymous 

this may not be exact solution but with some modifications you can achieve that: https://youtu.be/mJzDllAw4G4 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: www.youtube.com/@Howtosolveprobem

Regards

[Anonymous · Accepted solution]

I ended up using python with matplotlib and embeded into my Power BI report. I referenced the article below to get the multiple column and stacked columns. It's a little clunky and time consuming to make but very customizable which think I will need for future iterations of the report. 

https://gist.github.com/ctokheim/6435202a1a880cfecd71

[qqqqqwwwweeerrr · Accepted solution]

Hi @Anonymous 

this may not be exact solution but with some modifications you can achieve that: https://youtu.be/mJzDllAw4G4 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: www.youtube.com/@Howtosolveprobem

Regards

[Anonymous]

This is a great solution and very clever, I ended up using python using matplotlib but I will be using this in the future.

[lbendlin]

Familiarize yourself with the Deneb visual.  It's not trivial to implement your logic, but possible.  Make sure your users understand what they are looking at. (What's the point of the "Desired" column?  That could be a y axis constant line)