cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
msofficesolutio Regular Visitor
Regular Visitor

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 ?

14 REPLIES 14
prihana Member
Member

Re: filtering slicer/filter values based on selection in chart

Hi,

Filters doesnt work that way. As a workaround you can display a table with the district names.

quentin_vigne Senior Member
Senior Member

Re: filtering slicer/filter values based on selection in chart

Hi @msofficesolutio

 

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.

interactions.PNG

 

 

- Quentin

msofficesolutio Regular Visitor
Regular Visitor

Re: filtering slicer/filter values based on selection in chart

Hi Quentin,

 

Thanks for suggestion , i tried the same already but it didn't worked, is that working at your end ?

 

Manish

quentin_vigne Senior Member
Senior Member

Re: filtering slicer/filter values based on selection in chart

@msofficesolutio

 

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

prihana Member
Member

Re: filtering slicer/filter values based on selection in chart

 

 

It only works from filter to filter. Not from a chart to a filter.

Capture.PNG

 

As you can see, it filters the table. But not the filters.

msofficesolutio Regular Visitor
Regular Visitor

Re: filtering slicer/filter values based on selection in chart

will you be able to share sample workbook on which you are working ?

quentin_vigne Senior Member
Senior Member

Re: filtering slicer/filter values based on selection in chart

@msofficesolutio

 

I don't know I have this kind of visual and filter in my report 

nbtel.PNG

It probably works only for some visuals maybe 

 

- Quentin

prihana Member
Member

Re: filtering slicer/filter values based on selection in chart

Download sample

 

@msofficesolutio Please download it from the URL

msofficesolutio Regular Visitor
Regular Visitor

Re: filtering slicer/filter values based on selection in chart

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 ??