Set secondary Y axis value

Question

Hello everyone,&nbsp;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?

anonymous · Answer

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

michiel · Answer

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 · Answer

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

michiel · Answer

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

anonymous · Answer

You can try checking a custom visual here

Forum Discussion

Set secondary Y axis value

6 Replies

Related content

secondary axis

Combo Chart Disable Secondary Y Axis

Secondary Y axis not working

Hide secondary y-axis

Combo Chart - choosing secondary axis