Forum Discussion

ofeklevy's avatar
ofeklevy
Frequent Visitor
9 years ago

Secondary Y-Axis for Multiple Line and Bar Chart

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?

4 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    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's avatar
      macgyver
      Frequent Visitor

      Thank you. This was very helpful.

       

  • dkay84_PowerBI's avatar
    dkay84_PowerBI
    Icon for Microsoft Employee rankMicrosoft Employee
    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's avatar
      ofeklevy
      Frequent Visitor

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