PowerBI.tips

Tag: Filters

  • Apply a Filter to a Slicer

    Apply a Filter to a Slicer

    Often when working with a Power BI report you will add a slicer that has a “Blank” item in the selection criteria.  From a usability standpoint you might not want this item shown.  Or maybe you have multiple items in the slicer that you would like to hide from the report consumers.  The video, linked below, walks you through why the “Blank” item is shown and how to remove it.

    Video on Adding Filters to a Slicer

    Additional Slicer Materials

    If you want to read more about syncing slicers check the official documentation release from the Microsoft Power BI Blog.  This feature was originally released in February of 2018 and was announced here in the Power BI Blog.

    Thanks for watching.  If you like this content be sure to subscribe and follow along for more content.

    Subscribe to me on YouTube.  Or follow me on the social channels, Twitter and LinkedIn where I will post all the announcements for new tutorials and content.

    YouTube Linkedin Twitter
  • Dynamic Filters in PowerBI

    Dynamic Filters in PowerBI

    This video talks about how to create custom links that apply report level filters.  This is super cool and provides a ton of wide flexibility when building drill down reports.  In this example Patrick talks to filtering a report based on a Sales Person (Lilly Code).  Great technique for drilling down into subsets of data within a report.  If implemented in correctly this will enhance the user experience.

    Dynamic filtering with PowerBI:

    In the above video Patrick has referred to a previous video done by Adam talking about report filters within the URL query string.  For convience I have linked the referred video below, so you can watch it all in one place.

    If you haven’t already make sure you go check out Adam’s site and YouTube Blog for more great information.

    For more great videos about Power BI click the image below:

    PBI Videos