Forum Discussion

msofficesolutio's avatar
8 years ago

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

  • Hi,

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

  • 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.

     

     

    - Quentin

    • msofficesolutio's avatar
      msofficesolutio
      Helper II

      Hi Quentin,

       

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

       

      Manish

      • quentin_vigne's avatar
        quentin_vigne
        Solution Sage

        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