Persistent Filters (Reset to Default) now works with Custom Visuals in the Power BI Service

I was pleasantly surprised today whilst working on an older Power BI Report which had a few Chiclet slicers, and when I changed the selection of the Chiclet slicer I got the option highlighted “Reset to default”

I was actually so excited that I created this blog post on the way home from work, I simply could not wait until tomorrow!

Now when I hover of the “Rest to default” it now has a different tooltip, which now says:

Previously it said the following below:

I then created a quick report and configured it with my favourite Custom Visuals which are from the Filter Category.

  • Standard Slicer
  • Text Filter
  • Chiclet Slicer
  • Hierarchy Slicer
  • Smart Filter –  NOTE: The smart filter works but appears to not display the value when coming back to the report.

The results were fantastic in that each and every Custom Visual now works with the Persistent Filters.

As always, I really enjoy the comments and suggestions that I get to my blog posts. So please leave them below.

Power BI Infographic Update – June 2018

There have recently been quite a few changes and updates to Power BI, so in this blog post I have updated my Infographic. As well as put in references to where you can find more details on the updates that I have made to the infographic.

Below are the relevant links

Filter and Sort in the Data View in Power BI Desktop

Dashboard Themes in the Power BI Service

Persistent Filters for reports in the Power BI Service

Custom Data Connectors using the On-Premise Data Gateway in Personal Mode to refresh data

Incremental Data Refresh currently for Power BI Premium Customers

BI-Roundup – Power BI (Service & Mobile Update for March – Power BI is Hiring – Edit the Linguistic Schema for Q&A)

Here is the weekly BI-RoundUp.

Power BI – Service & Mobile Update for March

There were quite a few updates in the Power BI Service for March which was awesome.

There are now persistent filters, so that users can keep their own filters that they select on each report, which now works on both the Web and Mobile App

Organizational Custom Visuals are now Generally available.

Power BI has another certification which is HITRUST CSF certification

There is now also the mixed reality app using the Halo

The March Gateway update is available, which now not only includes the number, but it also shows the Month of the current update you have installed.

And finally, there is B2B support on the mobile app, so if you have an app shared with you from another tenant you can now see it in the mobile app.

All the details are here: Power BI Service and Mobile March Feature Summary

Power BI – Is Hiring

As you can see above the Power BI team is hiring. And quite a few roles at that, which I personally think is fantastic because it means that we can get more features quicker.

If you are interested you can find all the information here: Power BI is hiring!

Power BI – Edit the Linguistic Schema

There is a comprehensive blog post from Will Thompson in which he goes into great detail on how to edit the Linguistic Schema and enable your Q&A to answer more questions with additional synonyms and phrases.

All the details can be found here: Editing Q&A linguistic schemas

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.