Share via

Missing Month values

ron barlow 411 Reputation points
2020-11-10T17:38:52.577+00:00

I've got a line chart categorized by month as follows ...

38859-sc1.jpg

Some months are missing which I want to include a 0's. I've tried changing the Horizontal Axis properties to scalar using the Axis optionsbelow,

but the chart ends up as ...

38860-sc2.jpg

38809-sc3.jpg

Is there a way to set the values in the format MMM-YY. I could do it in T-sql but it will slow down the report generation.

Thanks
Ron

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,923 questions
0 comments
Accepted answer
  1. ron barlow 411 Reputation points
    2020-11-23T14:01:19.62+00:00

    Thank you.

    Sorry for the late reply

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 36,511 Reputation points
    2020-11-11T03:05:52.943+00:00

    Hi @ron barlow ,

    You may set the property of Horizontal Axis like shown, number-data.

    38896-screenshot-2020-11-11-105724.jpg

    In addition, what's the version of your report designer?

    I did some test and if the value is 0, it will also show the data. Mine is VS2017.

    38973-screenshot-2020-11-11-110342.jpg

    Regards，

    Zoe

    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.
    Hot issues October

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.