Forum Discussion

jijods4's avatar
jijods4
Frequent Visitor
7 years ago

Power Bi Custom Filter - How to add interaction with Multiple Categories

I am creating a custom filter in power bi. My basic idea is say, I have two categories "Category and Segment" , which has following values. Category -> Technology,Office Supplies, Furniture. Segment ...
Need Help
Nolock's avatar
Nolock
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi jijods4,

have you tried to use a slicer which has a horizontal orientation? You can create as many as you want direct from your fact table or dim tables and it'll filter your fact table as expected.

On the screenshot you can see two slicers and one table which is filtered by both slicers.

 

  • jijods4's avatar
    jijods4
    Frequent Visitor
    7 years ago

    Thanks for the replay.

     

    I have tried it but the problem here is only one caetgory can be accomodated here. If we have 3 categories namly country , state and district then we need 3 slicers basically.

    Instead of that what I am looking forward is a search area where we can search contry name, or state name or district name. and then filter happens.

     

    Any idea how we can impliment this..?