Aggregate Hourly Data to Weekly, Monthly, Yearly

Hello Power Bi Community,

I have hour data and when i drill up the Stacked Column Chart i can see per day and it is aggregated automatically but i also want weekly sum and monthly sum, yearly sum.

I have attached a Screenshot below for clear understanding.

Here when i select week in the time slicer filter it shows 7 days individually i want the total of 7 days same for month and year as well.

Please suggest a solution.

Thanks & Regards,

Ibrahim.