Missing Month values

Question

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

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 ...

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

Answer 1

Thank you.

Sorry for the late reply

Answer 2

Hi @ron barlow ,

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

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.

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