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.
0 comments No comments
{count} votes

Answer accepted by question author
  1. ZoeHui-MSFT 41,536 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 47,581 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' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.