Why are my Power BI Persistent Filters Not Working – Quick Tip
I was recently testing out the new Persistent Filters in Power BI and initially it would work with some reports and not with other reports. I even looked at imported data models, vs DirectQuery/Live Connection reports and I could figure it out.
So, I reached out to the very helpful people in the Power BI team, and they quickly showed and explained to me as why it was not working.
As explained in their blog post, it was my report having Custom Visuals.
For my report where I could not get the Persistent Filters to work, the best way for me to understand why it was not working, is to hover over the “Reset to default” item in the report.
As you can see below, it gives a clear indication that there are Custom visuals that are not currently supported.
Whilst on another report where I have no Custom visuals, when I hovered over the “Reset to default” I got the following Tooltip
Which indicates that I will be able to use the Persistent Filters due to the Tooltip letting me know I am using the authors default view. And no indication of any custom visuals.
Future Updates for Persistent Filters
As indicated in the comments section of the blog post the Power BI team is working to get Custom Visuals supported with Custom Visuals. Which I am certain will be sooner than later.
In my particular report I was using the Chiclet Slicer from Microsoft, and in my mind, I thought that this was one of the default slicers of which it is not.
As with my current testing as far as I can tell as at 19 Mar 2018, this is the only Slicer that is currently supported.
As always if there are any comments of questions, please leave it in the comments section below.
Gilbert,
If you had an embedded report and you changed the slicer selection in the service, would the new filter selection be persisted down to the embedded instance upon next refresh? Or do you have upload a new version of the report with the new slicer selection to the service before the embedded instance gets the refreshed slicer selection?
I know there is now Java code you can use to persist the filter selection in the embedded report, but was wondering if possible from Service.
Thanks in Advance, keep up the great work with the blogs.
Hi Ed, thanks for the comment!
Currently when working with the Power BI Service, I would make the change to the Power BI Desktop and then upload this to the service. This would then be the new default report look when people log into the report.
Does that help?
Thanks Gilbert, good interim solution but will work on Java code for long term fix. Thanks again.
No worries Ed, good luck