Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I have the following graph and I need to group the hours into 24 hours regardless of how many days I select on a slicer.
Currently it shows the hours correctly when I select 1 day, see below:
But when I select more days, it splits the hours per day. I want it for example, to show 9:00AM only once.
Please assist. How do I group the hours on the visual?
Thanks
Solved! Go to Solution.
@Tlotly , Have an hour column in your table or join with time table and use that on axis
https://kohera.be/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/
@amitchandak thank you for the response.
I did create hours already on my table and that is what I was using as an X axis, which doesn't show as grouped.
I also did create a time table but the relationship to my dataset is not working.I did ensure that both are using the same time format. Not sure if this could be that the dates on the timetable are out of range to dates on my dataset?
Dates on the timetable:
@Tlotly , Have an hour column in your table or join with time table and use that on axis
https://kohera.be/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/
@amitchandak thank you for the response.
I did create hours already on my table and that is what I was using as an X axis, which doesn't show as grouped.
I also did create a time table but the relationship to my dataset is not working.I did ensure that both are using the same time format. Not sure if this could be that the dates on the timetable are out of range to dates on my dataset?
Dates on the timetable:
Update:
I create a key on both tables i.e. and it's now working perfectly.
Thank you
User | Count |
---|---|
106 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |