Graph showing average of Last 6 days

[MGarza0720]

Hi all,

I'm having this issue where, for some reason I can't find a way to group the average of a day in a graph.

This might be something easy that I'm overlooking but hopefully you can help me get this done.

I need to display a graph showing the average consumption from the last 6 days. Something like the following graph but instead of months just days. Current day must always be displayed.

The issue that I'm having is that instead of showing the average of each day, its showing each individual record.
I'm using the following DAX measure to calculate the daily consumption

Daily_Consumption = SUMX(

                    VALUES(DateDim[Date].[Day]),

                    SUM(Consumption[Total_Consumption])

                    )

I do have a Date dimension but my date column in the original data does not have a hierarchy.

Attached is my file which contains all the data that I'm using.
https://drive.google.com/drive/folders/1Hr__-c3_hEcF3mxltQFAFgdiQ6X7Cog3?usp=sharing

Thanks for your help!

[HotChilli]

The measure shown above is not actually in the pbix.

--
The individual records are being shown because the date field from the Consumption table is used on the x-axis and it is a datetime (not a date)

Normally, you use the date dimension 'date' field and you make sure the relationship to the Fact table is working (same datatype)