question

agepeder-8878 avatar image
0 Votes"
agepeder-8878 asked ·

Fixating the horizontal major gridlines

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
image.png (13.8 KiB)
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

agepeder-8878 avatar image
0 Votes"
agepeder-8878 answered ·

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



image.png (25.8 KiB)
image.png (28.5 KiB)
· 1 · Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @agepeder-8878
Thanks for your feedback.
If you think the solution I gave is effective, please click "Accept Answer" and upvote it.

Thank you!
Best Regards,
Joy

0 Votes 0 ·
Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered ·

Hi @agepeder-8878 ,
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.

· Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.