Forum Discussion
Solved
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/...
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. :-)
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. :-)