Calculate average if date range is more than 1 day

[AI14]

Hi

I have a graph showing me arrivals per hour however when i put the date range to the last 7 days i get the 1st graph.

i want the graph to calculate the average number of arrivals per hours and display it in the desired layout and if 1 day is selected to also show the same layout.

what measure can i used to link data to slicer? 

last 7 days                                                 

desired layout

[amitchandak]

@AI14 , Use a measure like

Averagex( Values(Table[Hour]), calculate(Count(Table[column])) )

[AI14]

Hi,

Thanks for the reply.

im still getting the same layout - need the hours to be distinct and the values count averaged.