Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
msofficesolutio
Helper II
Helper II

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 15
quentin_vigne
Solution Sage
Solution Sage

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

Hi Quentin,

 

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

 

Manish

@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

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

Download sample

 

@msofficesolutio Please download it from the URL

Please accept my access request on gogle drive ..

@msofficesolutio Your org doesnt allow me to share.. Ill make the link public.

Hey buddy,

 

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 ?

 

filter screenshot.JPG

@msofficesolutio

 

Thats what i meant earlier as well. It doesnt work like that.

Is it possible to filter values in matrix on page 2 based on chart selection on page 1?

 

 

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

 

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

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

prihana
Helper V
Helper V

Hi,

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

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.