Forum Discussion
Helper VRunning 52 weeks - create filter for repport
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.
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.
Helper VThanks a lot Stephen, it seem very intuitive. At present I only export PowerBI as PDF,so i need the slicer to act as filter for all pages without being visible, aka as a normal filter.
What would be the optimal solution for doing so?