Paginated Reports missing Relative Date in Filters pane

[Anonymous]

Hi, 

I created a paginated report off of Power BI dataset.  In the Power BI report (that I am using as dataset)

I have a date filer as follows to bring back last 3 months of data:

TRUNC (TASK_CREATED) >= add_months(trunc(sysdate, 'MM'), -3)

AND TRUNC(TASK_CREATED) < trunc(sysdate, 'MM')

On the Power BI report, I have it Task Created date filtered on Relative date/is in the last/1/calendar months  (in the Filters Pane)

However, I don't see this option when I am in Paginated reports, so its bringing in all 3 months of data:

Is there an option somewhere to turn this on? or is this Paginated report limitation?

So what I am doing is creating another Power BI Dataset that only brings in last months data and creating report off of that for Paginated report.

Thanks for help!

[Anonymous · Accepted solution]

Thanks Rita, 

Thanks to this board I was able to search and find alternate solution,

I added custom calc and used this as filter on paginated report:

[Ritaf1983]

Hi @Anonymous 
It is possible only with some Dax approach.

Please refer to the linked discussion

https://community.fabric.microsoft.com/t5/Service/Relative-date-filter-for-paginated-report/m-p/1863599

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