Reset filter in PBi Service

[Syndicate_Admin]

Good afternoon

When you upload a report to the service, it publishes the file with all the data, without any of the filters defined on the desktop.

I give an example: on the desktop, I disable with a filter 5 providers that I do not want to be seen in the service. I publish it. When I go to the report, it shows me those hidden providers and I must press the Reset Filters button to show the data I wanted to show directly when publishing, without the data that I don't want the user to see.

I do not know if there is any menu option that you have to tikdar so that this does not happen, I do not know if it is a PowerBi error but it generates many problems because each user I must tell each user to press the button if you want to see the correct data.

It is very unreliable that in order to view the desired report, you must first press the button.

I publish a report. I consult it in the service and at first it does not apply the filters that were based on the desktop file. It shows the data without filters and you have to press the button to be able to see the data that is supposed, they can publish.

Thank you very much for the help.

Marcela

[V-lianl-msft · Accepted solution]

Hi @Syndicate_Admin ,

Are you using bookmarks ? Bookmarks are not updated with the new filter context. Once update the bookmark with the correct filter context, it will publish and work as expected.
Set the page with all filters as you want them. THEN and only then create a bookmark. Use the new bookmark to the page. If you created a bookmark already to the page, create a new one and change buttons to use new bookmark. 

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-bookmarks?tabs=powerbi-desktop#cons... 

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

[amitchandak]

@Syndicate_Admin , You have to save with parameter if you want filtered results. and then allow reset to have data.

Or create a parameter page, refer

Need Traditional Parameter Page: https://www.youtube.com/watch?v=F3qMwQtWjvo&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L&index=15

Display only one page in the report, Hide rest: https://youtu.be/d4H0GKUH0r4