cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Tyron Frequent Visitor
Frequent Visitor

Having date and hour on the X axis

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Having date and hour on the X axis

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

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

3 REPLIES 3
Community Support Team
Community Support Team

Re: Having date and hour on the X axis

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

7.png

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

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
Community Support Team
Community Support Team

Re: Having date and hour on the X axis

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

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

Tyron Frequent Visitor
Frequent Visitor

Re: Having date and hour on the X axis

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

 

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors