Forum Discussion

Fon's avatar
Fon
Frequent Visitor
6 years ago
Solved

Filter a slicer by another slicer

Hi all,

I have loaded a simple table in power bi desktop.

TypeProductquantity
vegetableeggplant10
vegetablecabbage12
vegetablepotato15
Fruitsapple5
Fruitsmango20
Fruitsbanana9

 

I have two slicers (type and product).

 

I would like the slicer Type to filter the slicer Product, but in the slicer Product all the options must be visible like below:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

In simple words, is there any way that a slicer can highlight another slicer? 

 

p.s. I have achieved  cross highlighting between a visual and the chiclet slicer, but i need to do it with another slicer.  

 

Thank you in advance

Xenofon

Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    hi Fon 

    To my knowledge, it couldn't achieve that highlight between slicer for now, slicer is used to filter data, not like other visuals to interact each other.

     

    Regards,

    Lin

8 Replies

    • Fon's avatar
      Fon
      Frequent Visitor
      6 years ago

      Thank you very much for your answer but it doesn't help. I didn't explain very well what i want to do. 

       

       

      • Fon's avatar
        Fon
        Frequent Visitor
        6 years ago

        When i choose fruits on the table, , then the chiclet slicer supports cross highlighting.

         

        i would like to achive this using the slicer type and not the table.

         

        Thank you in advance

  • mussaenda's avatar
    mussaenda
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hi Fon ,

     

    This is what you want to achieve, right?

     

     

    Just go to Format Tab and choose Edit Interactions.

     

    Click the Product Slicer

    then turn off the Interaction of the Type slicer

     

     

     

    and you're done.

    Choose Edit Interactions again once you are done.

     

    Hope this helps.