Monthly and weekly reports from a SharePoint List using Power BI?

[Pacadile]

I have a running SharePoint list called 'Equipment Log', this list has the columns:
'Equipment Name', 'Checked Out By' (the user's name), 'Check Out Date', 'Check Out Time', 'Check In Date' and 'Check In Time'

This list shows all the historical Check Out/Ins of our equipment. In Power BI I want to automatically create a new monthly report and new weekly report from my list with the titles March 2024, April 2024 and so on for the monthly report, and maybe March Week 1 2024, March Week 2 2024 and so on for the weekly report. Is this possible? I got as far as putting the SharePoint list on Power BI and thats working fine. Thanks!

[Pacadile]

youre amazing thank you!

[audreygerred]

Thank you so much - I am happy to help! You're doing great!

[audreygerred]

Hello - is there a reason you want separate reports instead of creating pages with filters that allow users to go to whatever month/week they would like? 

[Pacadile]

I'm not opposed to that, just not sure how to do it

[audreygerred · Accepted solution]

No worries! You would just create the report page(s) with whatever visuals you would like, then in the filter pane, add in the fields for month and week in the filters on all pages section (and anything else you want your users to be able to filter by).