A question about report design

苏川 梁 46 Reputation points

The left main Y-axis is a bar chart, and the right sub-Y-axis is a ratio and a line chart
I want the scale of the secondary Y-axis to be aligned with the scale of the main Y-axis, that is, the scale of the right Y-axis in the figure should be (0.0%, 1.0%, 2.0%, 3.0%, 4.0%, 5.0%, 6.0%), tried There are many ways but can't achieve it, I want to ask for help215531-snipaste-2022-06-28-09-10-58.png

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,736 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Joyzhao-MSFT 15,561 Reputation points

    Hi @苏川 梁 ,
    You can do this by setting the Axis Option in the Secondary Vertical Axis Properties.

    In my test, the design before setting Secondary Vertical Axis Properties is as follows:


    The preview is as follows:


    I set it up as follows:


    Preview now


    Best Regards,

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.