Forum Discussion

XavGozel's avatar
XavGozel
New Member
1 year ago
Solved

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 colu...
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.