Forum Discussion
Use two identical slicers for same visual
- 4 years ago
Hi v-xulin-mstf
Thanks for your suggestion, very helpful! I`ve tried to use it with the structure of my data and think we`re already very close to what I`m looking for. Please find attached my page based on your solution.
There are basically two things which I still need:
- How is it possible to select multiple peers at once, say A, B, and C and compare it with our focal company D?
- Is there an "easy" way to exclude the company selected as focal company in the pool of peers available for comparison? E.g. I first select company D as our focal company and then only A, B, and C should be available for selection.
Thanks a lot in advance!
- 4 years ago
Hi MSC
Try measure as:
Measure = IF( MAX(Data[Company]) IN ALLSELECTED(Company_peers[Peers]) || MAX(Data[Company]) IN ALLSELECTED(Company_focal[Focal]), 1, BLANK() )For the second requirement you describe, dynamic filtering of two dimension tables at the same time is not supported.
If you still have some question, please don't hesitate to let me known.
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
MSC , Are you trying to use two slicers on the same column. You need one or two independent table .
I have examples for date
Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI
Also this one
Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE
- MSC4 years ago
Helper III
amitchandakThank you for the quick response! I`ve to admit that I still don`t know how to approach my problem because in the videos you only use one slicer, right? How does the independent table help with two slicers?