Forum Discussion

bilingual's avatar
bilingual
Icon for Helper V rankHelper V
4 years ago
Solved

Running 52 weeks - create filter for repport

Hi, i am working on a report which is updated weekly, and which needs to run the last 52 weeks, can anybody help? 🙂   Kind regards Daniel
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi bilingual ,

     

    So you want to filter the data for the last 52 weeks, right?

    If you have a date column in your data source, then you can use a relative date slicer to filter:

    Use a relative date slicer or filter in Power BI - Power BI | Microsoft Docs

     

    There is a difference between Weeks and Weeks (Calendar), it can be found in the above document, which has an explanation.

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

bilingual's avatar
bilingual
Icon for Helper V rankHelper V
4 years ago

Hi , i periodically update the data every week by Excel files which has data from 2018, so when a new week is ready, i need a filter in the report which for example can be used to only show data greater than or equal to Week 1 2021 this week.

visheshjain's avatar
visheshjain
Icon for Impactful Individual rankImpactful Individual
4 years ago

Hi bilingual ,

 

I would suggest, that you create a YearWeek column in your calendar table, which will be numeric and then use that as a slicer on your report page.

You can create the slicer column based on the link I shared.

So the column will be 202101 for 2021 week 1, 202102 for 2022 week 2 etc. and the put this column as a slicer on the report page.

You can paste the same slicer on every page of your report, use sync slicers and hide it from the visibility pane from every page apart from the 1st page of your report. This way you have to make the selection only once.

 

Hope this helps.

 

Thank you,

 

Vishesh Jain