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.
Here is the Power BI workbook for your reference Limit slicer based on another slicer.
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.