Forum Discussion
filtering slicer/filter values based on selection in chart
Hi Everyone,
I have a chart showing sum figures distric wise wherease have one drop down filter showoing same distric names, i want that fitler should be filtered for distric name selected in chart ,how can i achive the same ?
Ex: if i select calafornia in chart ,filter should show only calafornia no other distric ?
15 Replies
- prihanaHelper V
Hi,
Filters doesnt work that way. As a workaround you can display a table with the district names.
- quentin_vigneSolution Sage
You should be able to do that.
Click on your visual
On the tab above the report editor you have :
Tools for visuals > Format
Click on Edit interactions.
Then choose wich other visual you want to filter, in that case your dropdown list, by clicking on the filter icon.
- Quentin
- msofficesolutioHelper II
Hi Quentin,
Thanks for suggestion , i tried the same already but it didn't worked, is that working at your end ?
Manish
- quentin_vigneSolution Sage
Yes it is working at my end, I'm able to filter them.
Did you change your relation to bi-directionnal filter in PowerBI ? Maybe it's only filtering from A to B and not from B to A if you have differents table.
- Quentin