Last day of month shown as next month?

[Anonymous]

Hello,

I have data with a number calculated by date.

The number for a month should be the number of the last day of the month.

So the number for January should be the number I have for 31 Jan, the number for February should be the number I have fro 29 Feb, etc.

This all works fine if I show these last date of the month values in a table.

However if I switch visualisation to ie. a line graph or bar chart, all of a sudden 31 Jan gets the x axis label Feb 2020, 29 Feb gets the x axis label Mar 2020.... If I hover over the line or bar I still see the date (31 Jan) in the tooltip, but the axis label shows Feb 2020... quite annoying.

The last line point / last bar has no label...

Any idea how to get this corrected?

Thanks for the help,

J

[amitchandak · Accepted solution]

@Anonymous , Just check is it showing date hierarchy. Then change it to date.

Also, make the axis as categorical

[nvprasad · Accepted solution]

Hi,

In the format section, under X-axis can you change from "Continuous" to "Catelogical".

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad

[amitchandak · Accepted solution]

@Anonymous , Just check is it showing date hierarchy. Then change it to date.

Also, make the axis as categorical