Secondary Y-Axis for Multiple Line and Bar Chart

[ofeklevy]

Hey,

I have a graph with 4 lines and 1 bar value.

3 of the lines and the bar chart hover to approximately the same value, and so a second Y-axis isn't necessary to differentiate between those.

I want to add that fourth line chart whose values only reach about a fifth of those of the bar chart and so I need a secondary Y-axis for THIS value alone.

Currenly I know how to create a secondary Y-axis but when I do it applies to ALL the lines, or to the bar chart, while I want it to apply only for 1 line.

Is this possible?

[v-yulgu-msft]

Hi @ofeklevy,

By default, the secondary Y-axis option applies to all lines in a chart. Currently, it is not available to make it only apply to one specific line. I would suggest you submit your request at this page: https://ideas.powerbi.com/forums/265200-power-bi-ideas If this idea is mentioned by many users, our product team will consider adding this feature in later release.

Regards,
Yuliana Gu

[macgyver]

Thank you. This was very helpful.

[dkay84_PowerBI]

Not possible. It's all or none. Of course you could use an R visual but your ask isn't available out of the box.

[ofeklevy]

Unfortunately I read that R visuals through PBI Desktop only process 150,000 rows, while my data set is much bigger.