Show report views per 24 hours on a graph.

[Tlotly]

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

[amitchandak · Accepted 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 · Accepted 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/

[Tlotly · Accepted solution]

@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]

Update:

I create a key on both tables i.e.  and it's now working perfectly.

       TimeKey = FORMAT('Reports-01'[TimeStart Hours],"hhmm")

Thank you