Forum Discussion
Sharing a Pre-Filtered Report using URL - Dates Between
In understand how to pre-filter a report for a given date using a URL
URL?filter=Table/Date gt datetime'2018-09-27T09:55:00'
I have a report which has a From and To date slicer.
From: 01/01/2019 To: 31/01/2019
How would I filter my report using a URL to cover this scenario?
Any help appreciated.
hi, msommerf
Try as below:
?filter=Time/Date ge 2019-01-01 and Time/Date lt 2019-12-31
For example:
https://app.powerbi.com/groups/me/reports/856aa87c-1f38-4e6e-943d-6cf38f5fbc3c/ReportSection3?filter=Time/Date ge 2012-01-01 and Time/Date lt 2012-12-31
https://docs.microsoft.com/en-us/power-bi/service-url-filters
Best Regards,
Lin
Lin, This works perfectly. Many thanks for taking the time to explain. :-)
2 Replies
hi, msommerf
Try as below:
?filter=Time/Date ge 2019-01-01 and Time/Date lt 2019-12-31
For example:
https://app.powerbi.com/groups/me/reports/856aa87c-1f38-4e6e-943d-6cf38f5fbc3c/ReportSection3?filter=Time/Date ge 2012-01-01 and Time/Date lt 2012-12-31
https://docs.microsoft.com/en-us/power-bi/service-url-filters
Best Regards,
Lin
Lin, This works perfectly. Many thanks for taking the time to explain. :-)