Forum Discussion

Ibrahim_shaik's avatar
Ibrahim_shaik
Icon for Helper V rankHelper V
2 years 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...
Need Help
Show and Tell
Tips and Tricks
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

weeks are incompatible with months and years.

 

Look into the Microsoft Timeline slicer visual.

  • Ibrahim_shaik's avatar
    Ibrahim_shaik
    Icon for Helper V rankHelper V
    2 years 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
      Icon for Super User rankSuper User
      1 year ago

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