Line and stacked column chard - Line based on column axes

[joshua1990]

In excel we have the wonderful functionality to use combo charts where we can select the secondary axes for individual measures.

In Power BI we just have the setting to add a single secondary axis for all lines values. Is it possible, when using 2 lines values, two ground the first value to the axis of the columns (Amount) and the second line value (percentage) based on the secondary axes?

[Anonymous · Accepted solution]

HI @joshua1990,

Nope, you can't direct achieve these on 'line and stacked column chart'.

If you are familiar with r/python scripts, you can try to use script-based visuals to manually plot these complex visausl effectes.

Create Power BI visuals using R - Power BI | Microsoft Docs

Create Power BI visuals using Python in Power BI Desktop - Power BI | Microsoft Docs
Regards,

Xiaoxin Sheng

[MFelix]

Hi @joshua1990 ,

You cannot set up different values for the same axis meaning that both lines would be the same has you refer.

On option can be using the charticulator that you can set a column and two different lines charts.