How to Create Organized Comparisons Between Two Representatives in Power BI

[alexandreneis]

Hello, I would like to know how I can create comparisons between two representatives in Power BI. The way I have set it up works to some extent, but when no representatives are selected, all of them are displayed, resulting in a cluttered view. I am looking for suggestions on how to create these comparisons in a more organized and creative way. Thanks in advance to anyone who can help!

[alexandreneis]

Thank you, my friend, I did it here and it worked!!

[Lucas_LP · Accepted solution]

Hello there!

Id reccomend creating 2 separate slicers, configure both to "single select" (this will imply there will always be 1 value selected.

While having a slicer selected, go to Format -> Edit Interactions. Set slicer1 one to not filter slicer2 nor visual2. Now click on Slicer2 and repeat the process.

Here is a general representation:

Otherwise, if you want to just use 1 slicer, you can set a limit of lines in the filter panel by selecting "Top N" by whatever value and condition you find fit.
If you just want to show 1 per visual, you can even set one visual to Top N 1 "First Representante" and the other to Top N 1 "Last Representante".
If doing this, always remember to click apply filter.