Aggregate Hourly Data to Weekly, Monthly, Yearly

[Ibrahim_shaik]

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.

[Ibrahim_shaik]

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.

[lbendlin]

weeks are incompatible with months and years.

Look into the Microsoft Timeline slicer visual.

[Ibrahim_shaik]

Hi @lbendlin ,

Thank you for the response.

How Should I achieve this with Timeline Slicer Visual.

alternate solution which i have is capture the weekly, monthly, yearly aggregated visual to a bookmark and access through bookmark navigator.

[lbendlin]

Instead of all that, train your users on how to operate the filter pane.