Dynamic Time X Axis with hourly data

Hi showy ,

Create a field parameter table with the columns you need for aggregation this will be something similar to this:

Parameter = {
    ("BIS", NAMEOF('F_Energieverbrauch'[BIS]), 0, 1),
    ("Date", NAMEOF('F_Energieverbrauch'[Datum]), 1, 2),
    ("Date", NAMEOF('F_Energieverbrauch'[Datum]), 1, 3),
    ("Date", NAMEOF('F_Energieverbrauch'[Datum]), 1, 4),
    ("Date", NAMEOF('F_Energieverbrauch'[Datum]), 1, 5),
    ("Date", NAMEOF('F_Energieverbrauch'[mONTH]), 1, 6)
}

Now create a relationship one to many between the parameter table and the Datumfilter table now you can have the aggregation has needed.

I have also created a month column for the last aggregation that you need at year level.
Check Bottom chart

Please see file attach.

Hi showy ,

The today is not working because you only have dates in the specific report you have sent until the 26 of August today is 27th so since your metric is getting the 0 days compared with today there is no data: