Dual Scale with 100% Stacked Bars

[Shri G]

Hi All,

I have to add line for record count in Bar chart visualization. I am using 100% stacked bars for visualization,

I tried to select dual scale on Value Axis but these bars are also getting changed into side by side appearance.

I want it to be like this:

Can Somebody please help me with your inputs?

Thanks in advance!

[Gaia Paolini]

I don't see an option for 100% stacked bars in a combination chart. I can get stacked bars as in this screenshot (Movies dataset)

[Jose Leviaguirre]

When using 100% stacked bars you will only have and need one scale that goes from 0 to 100%. A work around is to create a calculated column and compute the percentage for each bar / segment so you can have multiple scales.

It is a good use case, so I added this idea on the ideas portal.

[Shri G]

Thank you so much @Gaia Paolini (Employee)​ and @Jose Leviaguirre (Employee)​ for all your help!

I have created a calculated columns as suggested by Jose and It worked.