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.

     

     

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

Hi bilingual ,

 

You can hide the slicer from the visibility pane.

 

Thank you,

 

Vishesh Jain