Forum Discussion
Combo clustered Bar chart with One bar subdivided into different categories?
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.
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/@HowtosolveprobemRegards
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
4 Replies
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/@HowtosolveprobemRegards
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)
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
