Forum Discussion
Helper IVRelative date filter for paginated report
I have a relative date filter in Power Bi report.
When i create a paginated report from PBI, in the query it changes to fixed date filter.
How can I have relative date filter in paginated report similiar to Power Bi report
Paginated report filter query:
FILTER(
KEEPFILTERS(VALUES('Date'[weekending])),
AND('Date'[weekending] >= DATE(2021, 5, 14), 'Date'[weekending] < DATE(2021, 5, 21))
Power Bi filter:
1 Reply
- v-angzheng-msft
Community Support
Hi, amirghaderi
Creating a relative date slicer and filter or Using DAX may be a worthwhile approach.
For references:
Creating a relative date slicer and filter in Power BI
Power BI: Use DAX to get relative dates
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
