How to have the same divisions in the secondary y-axis of the chart in PBI Report Builder?

Dávid Juraj Szücs 0 Reputation points
2023-04-24T12:51:02.4133333+00:00

I have two y-axes in a chart in Power BI Report Builder, but I am having hard time harmonizing the intervals so that they would share the grid lines. Is there a way to set the number of horizontal grid lines for both y-axes?
User's image

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,826 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. AniyaTang-MSFT 12,331 Reputation points Microsoft Vendor
    2023-04-25T01:57:58.58+00:00

    Hi @Dávid Juraj Szücs

    There doesn't seem to be an option to set the number of gridlines directly, and the number of tick marks is generally changed based on the axis interval.

    I think you can adjust the number of your intervals to be consistent. Why do you find it difficult to coordinate intervals? For example, your secondary axis can be set to 7-35 and the interval is set to 7, you can try to see.

    I did a simple test. This is the setting for the secondary axis. 1

    Preview:

    2

    Best regards, Aniya