SSRS report - chart and x axis label positions

mark goldin 691 Reputation points
2021-08-31T19:25:16.947+00:00

I have a requirement for x axis date label positioning. Something like this:
Show three labels as much as possible in 0 position, and the end, and in the middle. If a period is to small, like one day, then one label at the end. Is there any mechanism to do that?

Thanks

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

1 answer

Sort by: Most helpful
  1. Joyzhao-MSFT 15,571 Reputation points
    2021-09-01T06:01:27.713+00:00

    Hi @mark goldin ,
    If you want to remove the margins of the category axis, make it close to 0 position, etc., it depends on what type of chart you use. In Bar, Column and Scatter chart types, the chart automatically adds side margins on the ends of the x-axis. You cannot change the size of the margin. In all other chart types, the chart does not add side margins. For more information , see Add or Remove Margins from a Chart (Report Builder and SSRS).

    By default, the chart will only display axis labels for data points in the dataset that contain valid values. For example, if you have values of 1, 2, and 6 on the category axis, the chart will only show categories 1, 2, and 6. To maintain the scale of category values, you can specify the chart to use a scalar axis. In this scenario, the chart will show labels for 1-6 on the x-axis of the chart, even though your dataset does not contain values for 3-5.

    For more information, please refer to: Formatting-axis-labels-on-a-chart-report-builder-and-ssrs.
    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 No comments