Forum Discussion
How to create a clustered & stacked columns graph
Hi,
I need to visualise in a unique graph clustered columns and each column must show a breakdown of values per colour (car names).
Currently, in PowerBi, I can only use a graph for clustered columns but breakdown is missing : this is to monitor a flow evolution (In, Out and still open) at the end of each period (Month) and visualise the evolution of the color values month after month.
Thanks for your help.
Hi XavGozel,
Thank you for reaching out in Microsoft Community Forum.
Thank you lbendlin for the helpful response.
To achieve clustered columns with a color breakdown in Power BI, please follow these steps:
1.Insert a Stacked Column Chart instead of a Clustered Column Chart.
2.set fields like below
Axis: Month (Period End Date)
Legend: Car Names (colors)
Values: Flow values (In, Out, Still Open).
3.To separate "In", "Out", and "Still Open" into different panels, use Small Multiples for better clarity.4.Create separate charts for "In", "Out", and "Still Open" if you prefer manual layout control.
Please continue using Microsoft Community Forum.
If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos' to help others find it more easily.
Regards,
Pavan.
8 Replies
Use a Ribbon Chart and hide the ribbons.
Hi XavGozel,
Thank you for reaching out in Microsoft Community Forum.
Thank you lbendlin for the helpful response.
To achieve clustered columns with a color breakdown in Power BI, please follow these steps:
1.Insert a Stacked Column Chart instead of a Clustered Column Chart.
2.set fields like below
Axis: Month (Period End Date)
Legend: Car Names (colors)
Values: Flow values (In, Out, Still Open).
3.To separate "In", "Out", and "Still Open" into different panels, use Small Multiples for better clarity.4.Create separate charts for "In", "Out", and "Still Open" if you prefer manual layout control.
Please continue using Microsoft Community Forum.
If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos' to help others find it more easily.
Regards,
Pavan.Hi XavGozel,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept as Solution" and give a 'Kudos' so other members can easily find it.
Thank you,
Pavan.Hi Pavan,
Sorry, I was off at work and thank you for your support as well as @lbendlin .
Unfortunately, it doesn't work because I can not select "Car Names (colors)" in the cell "Legend".
Car Names (colors) is not a computation, only ABC data with name.
I will send a picture of my PowerBi tomorrow.
Regards.
Xavier
Hi all,
Here is the snapshot of my PowerBi : following instructions hereabove, I can not drop "Car Name"
also, my need is to have a bar for each Y-axis computation, per month period, with, if possible, a curve of % (no shown in my example hereabove)
- 1 bar for Input
- 1 bar for Output
- 1 bar for WIP
Thank you for your help.
Hi XavGozel,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, kindly "Accept as Solution" and give it a 'Kudos' so others can find it easily.
Thank you,
Pavan.Hi XavGozel,
I wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If the community member's answer your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful.
If you need any further assistance, feel free to reach out.
Please continue using Microsoft community forum.
Thank you,
Pavan.
