Measure average of data between 7am to 7 pm & how to not have x axis slider in line clustered chart

[peoplehelpme]

i have 2 questions

1) how to calculate average of this [Total]

which i use this formula but, it returns in  blank

AvgTotal = AVERAGEX(

    FILTER(

        ALL(wgr),

        wgr[Time] >= TIME(7, 0, 0) && wgr[Time] <= TIME(19, 0, 0)

    ),

    wgr[Total ]

)

2) i want to fixed column bar in this chart (i want to see every bar as i selected date) but now it shown in slider x-axis (i think it might be relevant to multiple x-axis ([DateTime]&[Time]), i think i want to try date with time heirachy but i dont know how to write it)

[Anonymous]

Hi @peoplehelpme ,

In my tests, I can display the formula you provided correctly:

Also, if you don't want to display the x-axis as a slider, you can change the x-axis type:

Finally, if you want to display the corresponding results based on the selected date. You can create a date table as a filter with the following formula and then create a relationship between it and the wrg table.

Date_slicer = VALUES(wgr[Date])

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[peoplehelpme]

hi sir,

first row of chart is image that i want the chart will be, see all data in one page, no slider x-axis

[Anonymous · Accepted solution]

Hi @peoplehelpme ,

The line and clustered column chart does not support this display format.
I think it is possible to add the date field to the column legend as a basis for grouping and displaying all values.

M_ = SUM(wgr[Total])

Or only keep each date-based filter via bookmark. You can refer to below document:Create report bookmarks in Power BI to share insights and build stories - Power BI | Microsoft Learn

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.