Fixating the horizontal major gridlines

agepeder 271 Reputation points
2021-01-11T16:40:23.693+00:00

Im looking for a way of fixating the horizontal major gridlines. I need them to be positioned at 70 and 30. I am thinking of removing the major gridlines entirely and just add two striplines together with two textboxes indicating the level on the Y axis but I would prefer to do it with gridlines :)

an exaple with red lines below - disregard the existing gridlines.

55428-image.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,790 questions
0 comments
Accepted answer
  1. agepeder 271 Reputation points
    2021-01-13T19:31:22.01+00:00

    Hi,

    @Joyzhao-MSFT - thank you for taking your time to provide input for my question. I decided to with the striplines.

    56264-image.png

    56342-image.png

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,566 Reputation points
    2021-01-12T07:31:50.08+00:00

    Hi @agepeder ,
    According to your description, you only want to show 2 main grid lines in the bar chart, right?
    Usually, we can set the Interval and IntervalOffset properties to only control the display of the main grid lines in the bar chart. For example, if we specify the data field "SalesAmount" as the chart value, and another data field "Category" as the "category group", please refer to the following steps to configure the grid lines.

    1. With horizontal grid lines disabled, right-click on the Y axis and select "Show Major Grid Lines".
    2. Select the horizontal grid line in the chart.
    3. Set the Interval property to: = Count(Fields!Category.Value) (Note: This expression is used to evaluate the category interval.)
    4. In the IntervalOffSet property, when I set a value of 1, the first category will display the main grid lines. We can also use expressions to set the IntervalOffset property.
      Here is an example of displaying the main grid lines vertically, you can use it as a reference to set the main grid lines in the horizontal direction.Please refer to: Adding a Target line to a Horizontal Bar Chart in SSRS , then you just need to set the value to 30 or 70 in the IntervalOffSet property.
      If I have a misunderstanding, please feel free to correct me.
      Best Regards,
      Joy

    If the answer is helpful, please click "Accept Answer" and upvote it.
    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.

    0 comments