Space showing after last point in x axis of line chart

[obaidseer]

Hi,

I have a line chart which shows month ends in x -axis and the profit amounts in y-asis to show trend over the month in the year and for comparison with budget. The issue is after month end (like April, in this case), I have an extra space in x-axis. This is because I cannot manually include a maximum scale if I do categorical dates in x-axis and somehow my date labels are being read at month starts  which is why there is an empty space. Is there a quick hack to fix this. I think one option is to change the dates so that Jan 31 is actually read as Jan 1 and then change to continious and then it might work?

[rajendraongole1]

Hi @obaidseer - Can you set X-Axis to Continuous You can find this option under X-Axis, set the Type to Continuous from categorical.

or even we can add a new colum in your date table. "MonthEnd", EOMONTH ( [Date], 0 )

Try the above approach and let know.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[obaidseer]

I can do that but just to clarify, I do not have daily data, only data for the month. When I do continuous, the month label comes out wrong as jan 31 data is basically labelled as february as it is too close to month end. Not sure if it is better than just to leave like this and put some text boxes within the graph so it does not look like space was unintentional 🙂

Or maybe assume jan 31 data is jan 1 and then continious may make it more easy to read?

[v-jianpeng-msft]

Hi, @obaidseer 

Have you found a workaround or an alternative workaround for the current problem? If yes, you can share it here and then mark it as a standard answer so that others in the community can quickly find the answer when they have a similar question.

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-jianpeng-msft]

Thanks solutions from @rajendraongole1 

Hi, @obaidseer 

You can try turning off the display of items with no data in the X-axis.

If this doesn't solve the problem. You can set the x-axis field to continuous as RajendRaongole1 said. The idea you mentioned in your latest reply to add some textboxes to indicate that the blank space wasn't intentional is good. Of course, it depends on how you want to present your data. If these text boxes don't affect the presentation of your report, then it will work for you. If it affects you, then you can consider setting 1/31 to 1/1 so that the X-axis is a continuous date.

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.