Combo chart with multiple column series

[far]

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:

1. 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)
2. 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

[amitchandak]

@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

[far]

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?

[far]

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!