Scale secondary y-axis to primary y-axis

[pstaggers]

I would like the ability to scale a secondary y-axis to the primary y-axis on Line, Area, and Combo Charts.  My data has initial sales volume (over time) and then warranty and returns volume (lagging sales).  So, I would like to "align zeros" and then scale the secondary to X% of the primary using a rule/calculation.

Couple of issues:

1. "Align Zeros" under secondary y-axis options seems to be missing in newer charts

Older charts

Newer charts

2. No way to add the calculation here (when using fx button)

Appreciate any suggestions.  Thank you.

[v-luwang-msft]

Hi @pstaggers ，

Could you pls share your sample data and what visual you used？If new charts with no Align zeros and  old charts with Align zeros  is same visual ? In my test ,Align zeros could work .

Best Regards

Lucien

[pstaggers]

@v-luwang-msft Is there a way to upload a PBIX sample file to this post?  I don't see a file upload option.

[v-luwang-msft]

Hi @pstaggers ,

You could share your pbix file through a public link.Remember to remove confidential data.

Best Regards

Lucien

[pstaggers]

I tried to drag and drop the PBIX and got this 

Unfortunately, I am not sure how to get you my example other than screen shots.  Due to security reasons my IT dept does not allow DropBox or other file sharing applications.

[pstaggers]

Sorry, I don't have a "public link".  No way to upload the file directly here?  I see options for photos, and video, but I can't upload a PBIX?