Having date and hour on the X axis

[Tyron]

I am trying to plot values / numbers on a bar chart with the x -axis containing the date like 1st July 2019 then as you go along the x-axis, it goes up in 1 hour increments like 8 9 10 11 12 13 14 15 16 17 18 then 2nd July 2019 with the same hours 8 9 10 11 12 13 14 15 16 17 18 etc. Hope that makes sense

So far I have been only able to have one or the other on the x-axis but would be great to know how to have a continuous date and hour on the x-axis.

[v-diye-msft]

Hi @Tyron ,

Based on my research, we’re able to set both date and hour in the X-axis, but the minimum interval is 3 hours. The chart could be shown like below:

All time involved, but only 3.6.9.12 clock listed in the X-axis

Please share your idea here if you’d like to bring the 1 hour-interval feature coming:

https://ideas.powerbi.com/forums/265200-power-bi-ideas

Best regards,

Dina Ye

[v-diye-msft · Accepted solution]

Hi @Tyron ,

If my above post helps, could you please consider Accept it as the solution to help the other members find it more quickly. thanks!

Best regards,

Dina Ye

[Tyron]

Hi Dina

On the fields for the visual, can you let me know how you got the time on the X-Axis, was there a setting in the fields or format area, just having a blank when it comes to that.

Also my data is in separate columns for date, time and hour [eg 06/08/2019, 08:35:22 AM, 8] and this seems to mess up the graph. I am assuming from your example the date and time needs to be in the one column but in regards to the value how is that collated if you have a value of 1 next to each time stamp,

eg

06/08/2019 08:35:22 AM = 1,

06/08/2019 09:30:47 AM = 1,

06/08/2019 10:15:10 AM = 1,

06/08/2019 12:45:05 PM = 1 etc