Forum Discussion
Combo chart with multiple column series
Dear fellow Power BI users,
I have been trying to reproduce the following excel chart in Power BI:
But only can do this:
When trying to create a combo chart in Power BI with the same data, I run upon two problems:
- I cannot choose two variables for the column series so as to have both NAME and Number (see that NAME is also collapsed for 2021 in the pivot table/chart)
- I cannot choose independently for different values in the chart if I want a line chart or a stacked column like I would do in excel.
The data I'm using is the following:
Where I have unpivotted the columns to have:
Any help in the matter would be much appreciated
3 Replies
far , You can use two legends or two measures with legend on stacked visual
REFER these
https://github.com/microsoft/charticulator/issues/219
https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa200001934?tab=overview
Hi amitchandak ,
I cannot find a tuto on how to produce a line chart over a stacked colument chart like the one I showcased with charticulator.
Could you point me on how to do it?
Thanks!
Hi amitchandak , would you have any advice on how to create a mixed chart in Charticulator so as to have both a line and a bar chart on the same graph?
