Filter One Slicer Based on Another Slicer in Power BI - Excelerator BI

Filter One Slicer Based on Another Slicer in Power BI

This is a follow up article from my last blog post where I demonstrated how easy it is to use two slicers to compare any two items. In the demo in my article, I specifically showed how you could compare any 2 years of choice, but the principle applies to any two products, any two customers, or any two of anything. At the bottom of that article, there was a comment from Artur asking if there was a way to limit the choices in the comparison slicer to exclude the item selected in the first slicer. E.g.

If I select Year = 2016 in slicer 1 below, then I don’t want to see Year = 2016 in the comparison slicer 2 below.  I thought that was a great question/suggestion and hence that is the topic for today.

In the video below, I go into the thought processes I went through to solve this problem, and of course show you how to do it for yourself.

The videos I share on my site are bespoke solutions to specific problems.  If you would like a more comprehensive, curriculum based learning across Power Query, Power BI, DAX, and Excel, you should check out the full suite of courses Ken and I have available at Skillwave.Training.

6 thoughts on “Filter One Slicer Based on Another Slicer in Power BI”

  1. I loved this video–so helpful for users to be able to filter cleanly and have a more streamlined user experience. I am going to apply this method to my reports that feature year comparisons.

    1. Great video Matt. Thanks for that.

      I was surprised you were able to use selected value on compyear. I thought that only worked when a single value was selected. I guess that’s the case once you get to the rows in the slicer but just a little confusing.

      1. Matt Allington

        In my video, the matrix had comp year on the rows of the matrix. The matrix filters the model using the rows as the filter source. The filtering behaviour of rows in a matrix is identical to a slicer albeit displaying many results at once. You can see many, but they are filtered “one at a time”. The same applies for an axis in a chart, or slices in a pie chart, etc.

        That’s why it works.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top