A question about report design

苏川 梁 46 Reputation points
2022-06-28T01:17:43.35+00:00

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,128 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Joyzhao-MSFT 15,361 Reputation points Microsoft Employee
    2022-06-28T06:52:30.51+00:00

    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:

    215559-02.jpg

    The preview is as follows:

    215537-03.jpg

    I set it up as follows:

    215626-04.jpg
    215566-05.jpg

    Preview now

    215615-06.jpg

    Best Regards,
    Joy


    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.