How to sync the axis

[safsad]

 How do i synchronize both the axis ?

I'm new to PowerBI ,any help is greatly appreciated , Thanks.

[v-eqin-msft · Accepted solution]

Hi @safsad ,

According to my understand , you want to use the same Y-axis in Line and Stacked chart, right?

You could drag both Actual Hours and Quoted Rework Hours to Column values like this:

Or Enable “Show Secondary” firstly and then disable it again like this:

 

Did I answer your question ? Please mark my reply as solution. Thank you very much.

If not, please upload some insensitive data samples and expected output.

Best Regards,

Eyelyn Qin

[Anonymous]

You can set the minimum and maximum range of both axis to be the same.  It's not the ideal but it seems to be the best solution in Power BI (so far).  Tableau made this option very easy.  

[v-eqin-msft · Accepted solution]

Hi @safsad ,

According to my understand , you want to use the same Y-axis in Line and Stacked chart, right?

You could drag both Actual Hours and Quoted Rework Hours to Column values like this:

Or Enable “Show Secondary” firstly and then disable it again like this:

 

Did I answer your question ? Please mark my reply as solution. Thank you very much.

If not, please upload some insensitive data samples and expected output.

Best Regards,

Eyelyn Qin

[safsad · Accepted solution]

Thank you so much for the detailed solution.. It did work by the second solution ,"Enable “Show Secondary” firstly and then disable it again like this:" 

I greatly appreciate your time for helping me 

[amitchandak]

@safsad , You can not do that. Disable seconday Axis in Visualization format. Line should come on the first axis .

[safsad]

HI Amit,

Thanks for the prompt reply.  I tried to disable the Y axis.  The  blue dot i marked is supposed to be inside the yellow bar right ?

Can you pls chk what did i do wrong ?

nks for the prompt reply.  I tried to disable the Y axis.