Forum Discussion

hstangelo's avatar
hstangelo
New Member
2 years ago
Solved

Align zeros is not working

I have a bar/line chart combo and I would like the y axis aligned with the secondary axis. When I press "align zeros" as an option on the secondary axis, they are still no aligned. As you can see in the picture below, the secondary axis line is at a fixed value of 5.4, and the bar chart with a value of 5.8 is lower than the line instead of higher. Am I missing a step to align the axes?

 

  • Anonymous's avatar
    Anonymous
    2 years ago

    Thanks for the reply from ryan_mayu , please allow me to provide another insight:
    Hi,hstangelo 

    1.First I have created the following table and the column names and data are the data you have given:

    2.Based on my understanding of your requirements, you can make the following changes to the visual object:
    First, turn off the “values” option:

    Second, turn off the “zoom slider” option:

    3.Here's my final result, which I hope meets your requirements.

    Please find the attached pbix relevant to the case.

    Best Regards,

    Leroy Lu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     





4 Replies

  • thanks for your resposne, but that only toggles the zoom slider on and off for the secondary axis. It doesn't actually turn off the secondary axis.

    • ryan_mayu's avatar
      ryan_mayu
      Icon for Super User rankSuper User

      could you pls provide some sample data or pbix file?

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks for the reply from ryan_mayu , please allow me to provide another insight:
      Hi,hstangelo 

      1.First I have created the following table and the column names and data are the data you have given:

      2.Based on my understanding of your requirements, you can make the following changes to the visual object:
      First, turn off the “values” option:

      Second, turn off the “zoom slider” option:

      3.Here's my final result, which I hope meets your requirements.

      Please find the attached pbix relevant to the case.

      Best Regards,

      Leroy Lu

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.