Line and Column Chart - Keep both line and column in the left side y axis

[Anonymous]

Hello Dear Experts,

In order to facilitate the chart visualization I need to keep both Line and Column data in the same Y axis (left side). 

In both data I'm using Percentage, so the minimum value is 0% and max value is 100%.

As we can see below due the value difference between line and bar, Power BI is changing the UF% indicator to sencond Y axis.

Thanks in advance,

Best Regards,

Luciano Motta

[sayaliredij · Accepted solution]

You have to select clustered column and line chart.

The one you are selecting is a stacked column and line

Regards,

Sayali

If this post helps, then please consider Accept it as the solution to help others find it more quickly.

[Anonymous]

Hi Sayali,

Thanks for your help.

As we can see I do not have the option to show off secondary axis. It can be due to product  version ? I'm running on: 2.76.5678.782 

Thanks again.

Luciano

[sayaliredij]

You can do the following formatting change

Make Secondary axis of and you will have the result you wanted

Thanks,

Sayali

If this post helps, then please consider Accept it as the solution to help others find it more quickly.