Displaying Only Last Data Label Values in Line Charts

Yassir 201 Reputation points
2023-01-26T00:32:04.0866667+00:00

Hello,

i have a report like a bellow

User's image

I want the green line cover all the row and display only the one value , i would like something like as bellow

User's image

I don't know if that possible in ssrs or not ?

Thanks for help

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

Accepted answer
  1. ZoeHui-MSFT 40,356 Reputation points
    2023-01-26T06:20:44.4766667+00:00

    Hi @Yassir

    Here is a workaround to do that.

    1. Click on Y-axis. Then go to Properties, click ellipsis in StripLines.

    2. Add a strip line, set color and offset value.

    3.Set the Vertical Axis property--set the maximum value over 30(or it may not show the line.)

    User's image

    User's image

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Olaf Helper 45,881 Reputation points
    2023-01-26T06:45:40.6433333+00:00

    I don't know if that possible in ssrs or not ?

    No, it's not possible with the available build-in controls/features.

    You could only try to add a textbox and try to get the figure value for it.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.