Power BI - Directly Compare Two Categories (Slicer Filters Other Slicer)

In this Power BI tutorial, we learn how to compare two categories against each other using DAX. This technique will show you how to set up two slicers that filter each other so that you can't select the same category in both slicers. Next, we learn how to take our two selections and plot them visually.

To enroll in my introductory or advanced Power BI courses:

Blog Post/PBIX Download:

Elite Power BI Consulting:

Data Insights Tools:

Connect with me on Twitter!

[simphiwe_stb]

I've been binge watching all your videos, and the learnings are just so much. Thank you

[tamasbencsik]

BRILLIANT!! I have been looking for this for so long now! Thank you for the great explanation!

[hotfox]

Awesome! You saved to me lots of learning time by publishing this clear and well-described solution.

[sabanasir]

Fantastic. I went through so much stuff but this is a jackpot! thank you for this✌

[hazel-hanavu]

Clear-cut presentation and DAX use! I'm so glad I stumbled upon your video. Subscribed!

[jerriclark]

Thank you so much for this! Can you please show how we can sum multiple categories in each slicer for comparison? For example, the sum of sales in California and Washington, vs the sum of sales in 5 other states.

[tiagopardo]

I've been looking that for so long.

[joseluisbeltramone]

Excellent explanation. Thank you very much!

[sammiyin]

Exactly what i am looking for. Thank you!

[venkat]

great work..this is in my current requirement but i couldn't achieve. Now i will implement the same..thank you

[willlopez]

Super helpful! great job & Thanks for sharing!

[abhishekstatus_]

Thats really awesome Parker !! Thanks for sharing :)

[jaimeekatz]

This is awesome, thank you! Is there a way to create a measure that displays the variance of the two selections?

[vipulgoel]

Great Video ❤❤!! This was exactly my requirement and now I have achieved that with the help of this video. Just one more thing I would like to know, I have 4 Visuals on a page and 3 of them I have created using measures as explained in the video, but one of them is a Table visual which is utilizing only the fields from the source table and no measure is used in that table visual, so that table visual is not filtering out based on the slicer selection, can you please help with that, it would be really helpful. Thanks 😊

[vikramsingh-wsnn]

Thank you so much BI Elite. I am your fine

[amansingh_]

Useful one, but my question here is if we are creating a dashboard in page where we are using "category name" as a slicer too and then I want to use it, then according to the slicer I don't want to change this slicers, how to make it possible

[Scorpiank]

If we enable multiple selection in the second slicer, will it still work? Or what should be the change in the dax measure?

[carlosfrm]

Great! i wonder if its possible to create a filter out a filter, lets say one main filter in which you select the measure to compare and based on this selection Filters A and B can be compared

[bhagirathiramesh]

how about multiple second scenario selection?

[venkat]

but i don't have measure to use in my Gantt chart so in this case how to proceed. appreciate your response