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.
 |
 |
 |
Cool alternative to applying a filter to the page or report level through the filter pane. Although what’s really needed here is the ability to apply visual level filters in the filter pane: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/12545673-visual-level-filtering-in-slicers
A very elegant solution. Thank you so much.
Hi Mike , I like particularly the idea of a Master Slicer page. Thank you for sharing.
What is your opinion about filter Sales with a join on the query to remove prod 4 from fact table? Of course, only if we don’t need prod 4 transaction for other analysis.
Cheers
I have used specific data sets to filter out data points, just as you have described. Sometimes when modeling data you need to remove more than one item. Maybe you want to remove 10 or 100 items. Thus, it would be impractical to use an if then statement to filter everything out. Instead I would make a separate data table and use that to filter out the items I don’t want. This allows me to change that Filter out list at a later date if needed.
Its a good solution, although not always practically feasible to go and change the default selections when new values come in for a field.
Regards
This is an excellent solution and well explained too. Thanks so much for the tip.
Genius!
Ahhhhh mate!!! you saved me. I was about to loose hope and I found this, its so obvious really! Thanks for shining the light
Now that visual level filters are available for slicers too (June 19 release of Power BI Desktop), there is a simpler alternative. But this has certainly helped many in the meantime.
Yes, the return of filters being directly applied to a slicer has been the solution we’ve been wanting. Thankful this feature has been added.