cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 393 members 3,258 guests
Please welcome our newest community members: