Forum Discussion
How to indirectly filter visual?
Hi, I have a visual that shows the Visits per Company. When I select a certain Company in a slicer, I want the visual to only show the copmanies that have the same value in the field Peer Group as t...
Hello maflingo
Add this measure to your visual.
FilteredVisits =
VAR SelectedPeerGroup = SELECTEDVALUE(Startups[Peer Group])
RETURN
CALCULATE(
SUM(Startups[Visits]),
FILTER(
Startups,
Startups[Peer Group] = SelectedPeerGroup
)
)
Ensure the slicer is filtering only the Company field.
The measure will dynamically adjust the visual to show only companies in the same Peer Group as the selected one.
Thanks,
Pankaj
If this solution helps, please accept it and give a kudos, it would be greatly appreciated.