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 ?
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.
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.
i think it's still not working, you can see in screenshot currently city Kandy is selected in pie chart, it has filtered table in right hand side but filter in left hand side is showing all districs, ideally as per our req it should show only Kandy ?
I don't know I have this kind of visual and filter in my report
It probably works only for some visuals maybe
I just realised if filter is chiclet slicer then it's filtered based on chart value selection but normal filter is not fitlered based on chart value selection ??
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.