New Filter Experience for Power BI Reports

Announcing the New Filter Experience for Power BI Reports

The wait is over!

Power BI has announced that the new filter experience is now generally available. We have updated the look and feel and added a ton of new functionality.

Let’s walk through what’s included in the new filter experience.

Pop-up Filter List

With the new filter experience, report consumers can hover over the filter icon in the visual header to see and read-only list of all the filters or slicers affecting that visual. This makes it super easy for end-users to understand what filters are applied to a visual.

Here are the types of filters this view shows:

  • Basic filters
  • Slicers
  • Cross-highlighting
  • Cross-filtering
  • Advanced filters
  • Top N filters
  • Relative Date filters
  • Sync-slicers
  • Include/Exclude filters
  • Filters passed through a URL

Format and Theme

Report creators now have control over the look and feel of the filter pane. The goal here is to make your filter pane feel cohesive with your report.

You can also modify the default formatting of the filter pane with a JSON theme file.

Lock and Hide Filters

You can now lock filters so that report consumers can see that those filters are applied but they cannot modify them.

Additionally, you can hide filters from your report consumers. Hiding filter cards is typically useful if you need to hide data cleanup filters that exclude nulls/blanks or unexpected values. Hidden filters don’t show up in the filter pane nor the filter dialog for a visual.

Sort Filters

Report creators can custom sort their filters in the new filter pane. This is helpful if you want certain filters to be pushed to the top or if you want certain filters to be next to each other.

new filter experience

You can also choose to alphabetically sort the filters.

new filter experience

Rename Filters

You can double-click on the filter car titles to change the display name so that they are more user-friendly for your report consumers.

new filter experience

When you update the display name, it also gets updated in the filter dialog.

new filter experience

Capture Filter State in Bookmarks

With the new filter pane, you can capture the visibility and expanded or collapsed state of the filter pane in your bookmarks. This is useful when you want to customize how the filter pane fits into your data story:

  • Hide the pane when you don’t need it.
  • Collapse the pane when you need more horizontal real estate for your canvas.
  • Keep the pane visible and expanded when you want users to interact with it.

new filter experience

Learn more about Power BI capabilities and get in touch with allonline365 if you are ready to transform your reporting. Contact us on  info@allonline365.com or  +27 (21) 205 3650.

www.allonline365.com 

Resource Credit | Power BI

xxx

Comments
  • Willis Skar says:

    I simply want to mention I am just very new to weblog and really loved you’re website. Most likely I’m likely to bookmark your blog . You really have really good stories. Bless you for sharing with us your web page.

Leave a Reply

Your email address will not be published.

Call Now Button