Forum Discussion
Help making combo chart with multiple lines in PowerBI desktop
Hi ldelgado622 , Thank you for reaching out to the Microsoft Community Forum.
I recreated your scenario using sample long-format data and built the visual in Power BI. The attached .pbix shows the correct way to represent this requirement using a stacked column chart. Each bar represents total events by Year_Q and the stacked segments represent the Site of Service breakdown within that quarter. The total height of the bar is the total volume, while the relative size of each segment reflects its share. I added a % by SOS measure to tooltips so you can see the exact percentage on hover. This approach remains fully filterable by both Event and Source.
The reason the combo chart approach did not work is a limitation of Power BI visuals. A Line & Clustered Column chart only supports a single line and does not allow a legend on the line axis, so SOS cannot be split into multiple percentage lines. Because of that, the stacked column chart is the correct and supported way to show “total volume + SOS composition per period” in one visual.
Please take a look at the .pbix for reference.
I tried this, but I only have a column legend and no legend option for the line y-axis. When I'm in the visualizations pane, i only have x-axis, column y-axis, line y-axis, column legend, small multiples, tooltips. So I'm stuck only having one line representing the % SOS breakdown that is currently just straight across the graph. What else could i try?
v-hashadapuCommunity Support
Hi ldelgado622 , Thank you for reaching out to the Microsoft Community Forum.
I recreated your scenario using sample long-format data and built the visual in Power BI. The attached .pbix shows the correct way to represent this requirement using a stacked column chart. Each bar represents total events by Year_Q and the stacked segments represent the Site of Service breakdown within that quarter. The total height of the bar is the total volume, while the relative size of each segment reflects its share. I added a % by SOS measure to tooltips so you can see the exact percentage on hover. This approach remains fully filterable by both Event and Source.
The reason the combo chart approach did not work is a limitation of Power BI visuals. A Line & Clustered Column chart only supports a single line and does not allow a legend on the line axis, so SOS cannot be split into multiple percentage lines. Because of that, the stacked column chart is the correct and supported way to show “total volume + SOS composition per period” in one visual.
Please take a look at the .pbix for reference.