Sharing a Pre-Filtered Report using URL - Dates Between

[msommerf]

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.

[v-lili6-msft · Accepted solution]

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

[v-lili6-msft · Accepted solution]

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

[msommerf · Accepted solution]

Lin, This works perfectly. Many thanks for taking the time to explain. 🙂