Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All,
I working with a dataset where Im trying to achieve a hourly breakdown of the number of users that that attend our website.
The data has timestamped the date and time the user arrives on the website. I have spilt the data and time into separate fields and used the data as a slicer (see image).
I then extracted the hour from the time field and wanted to express it as a bar graph showing the busiest hours of the day.
However, I am finding this difficult to implement. I want a graph on the x-axis of the hours of the day 00 -23 hours and and the y-axis a count of the number of users.
Currently, I cant get the time in chronological order. It jusmps for example from 0, 2, 3, 13, 1 ....
Secondly, those hours that have 0 visits isnt shown in the graph. I was thinking of joining a separate hour table but the logic looks complicated on paper.
It looks like a straightforward task and I hope that I am overlooking something. Any suggestions or resources that could help me overcome this would be grateful
Solved! Go to Solution.
@Anonymous , I think this data is sorted Ascending on Measure/value. Check the option in three dots and correct it
Or create an hour field like this and use on axis
hour = hour([datetime])
@Anonymous , I think this data is sorted Ascending on Measure/value. Check the option in three dots and correct it
Or create an hour field like this and use on axis
hour = hour([datetime])
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
88 | |
82 | |
65 | |
64 | |
58 |
User | Count |
---|---|
171 | |
112 | |
110 | |
72 | |
72 |