How to apply URL date filter when we have date slicer on report

[ravitejaballa]

Hello,

I am try to apply URL filter on my report but it does not work as it already have date slicer on report.

How to override or clear date slicer before applying URL filter?

Eg:.

I have a CalenderTable (From 1st Jan 2017 to 31st Dec 2021) with datetime as column.

Report have date slicer which set to some value as below and published to power bi service.

I have data beyond 26 Feb, So I tried to apply URL filter to see data.

?filter=CalenderTable/datestamp ge '2021-03-02' and CalenderTable/datestamp le '2021-03-05'

As date slicer set to 22nd Feb to 26th Feb. 

URL filter not able to apply.

How to resolve this?

My actual usage is to use this filter string in "Export to File" API

PowerBIReportExportConfiguration => reportLevelFilters

[v-yangliu-msft · Accepted solution]

Hi  @ravitejaballa  ,

Create some data:

The definition rule is: use the url parameter to filter the data with the date from 2022.26 to 2021.3.2

Here are the steps you can follow：

1. Publish the PBIX file to power bi services in this form.

2. Select the logo eraser, cleanup

3. Place the url parameter in the browser URL

https://app.powerbi.com/groups/f98bd576-9883-42cd-b83a-b2ce7cc011b3/reports/9216c96e-85f0-443c-b545-...

4. Result：

Best Regards,

Liu Yang

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