Set secondary Y axis value

[JMAFO]

Hello everyone, 

I am using a line and clustered column chart and I wish to have the secondary axis only display percentages. I'm using two lines for percentage and a bar for dollar amounts. Whenever I add another column to the line value, it changes the secondary Y axis to dollars, instead of percent. How can I make sure that the newly added column uses the primary Y axis rather than altering the secondary Y axis?

[Michiel]

In this visual, one axis is for columns and the other for lines, if you use a secondary Y-axis. You cannot mix columns and lines on one axis if you do have a secondary.

[JMAFO]

Is there a visual in which I can? This is extremely simple to do in excel. 

[Anonymous]

You can try checking a custom visual here

[Michiel]

I'm not sure. But it sounds confusing to me.

[JMAFO]

This is what I wish to do. The blue bar and the red line both use the primary axis (on the left) and the gray and yellow lines use the secondary axis (on the right). 

[Anonymous]

To the best of my knowledge, with some custom visuals you can decide to use a bar chart for one axis and a line chart for the other. Not mixing line and bar on one axis and another line on the secondary axis.

You can however check custom visuals in the marketplace. Try Combo chart and Power KPI