Forum Discussion
How to Create Organized Comparisons Between Two Representatives in Power BI
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!
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.
2 Replies
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.Thank you, my friend, I did it here and it worked!!
