How do I make my graps display dates instead of day numbers?

[carinat]

Hi all, I have a column chart with dates on the x-axis. I want to drill it down to day level for several months but when I do that, it accumulates days for different months. So the value of day 1 contains both that of May and of June. How do I instead of day numbers just show a date scale?

[carinat]

I solved it myself by accident. It turned out that I couldn't have times in my date field as well (if I wanted to show dates in my charts and not numbers), so I calculated a new column with dates only and used that instead.

[carinat]

Okay, not solved. Now I have the same problem with data in another table. Does anyone know what the cause could be?

[CheenuSing]

Can you please share more details about the problem you want to solve.

Cheenusing

[carinat]

When I use my date columns on the x-axis of graphs and drill it down to day level, the axis shows day numbers instead of dates. That means that the scale also goes beyond what is possible for dates (see the x-axis continuing to 35). I also attached the graph at month level (it does indeed know that I have a time measure since it displays year, quarter, month correctly but when I drill to day level things go wrong. My date column and type looks like it should.

I need it to display dates because I don't want the value for May 1 and June 1 to accumulate at "1". Instead I want June 1st to come after May 31.

[KHorseman · Accepted solution]

Look at the axis well for that visual. Is it showing your date field as date only, or is it showing date hierarchy?

[carinat]

Thanks! I was about to go insane. Did not know that that could be changed 🙂

[KHorseman]

Yeah it can be changed. Now the real question is, why is the hierarchy the default?

[carinat]

Probably because it seems fancy to beginners and then you don't need to make your own hierarchies (also just realized that you could do that) before getting started for real. But I agree that it would be better to make date default instead of hierarchy.