Forum Discussion

Ibrahim_shaik's avatar
Ibrahim_shaik
Helper V
1 year ago

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.

 

Need Help
Show and Tell
Tips and Tricks

4 Replies

  • Ibrahim_shaik's avatar
    Ibrahim_shaik
    Helper V
    1 year ago

    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's avatar
    lbendlin
    Super User
    1 year ago

    weeks are incompatible with months and years.

     

    Look into the Microsoft Timeline slicer visual.

    • Ibrahim_shaik's avatar
      Ibrahim_shaik
      Helper V
      1 year ago

      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's avatar
        lbendlin
        Super User
        1 year ago

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