Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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
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
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
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