Forum Discussion

ack2mani's avatar
ack2mani
Frequent Visitor
8 years ago

Multiple Slicers on same query

Hi All,   I am new in Power BI and stcuked in a situation where I have two slicers 1. Head Office 2. Branch Office in a report page. I have one query that contains full adress of both Head Office a...
MFelix's avatar
MFelix
Super User
8 years ago

Hi ack2mani,

 

Can you pleasse share some sample data and expected result.

 

Regards,

MFelix

 

 

 

ack2mani's avatar
ack2mani
Frequent Visitor
8 years ago

Hi MFelix

 

below is the sample

 

Slicer 1(Regional Head Office  Id)
1
2
3
Slicer 2 (Branch Offices id)
123
567
345

   

Office Address
IDAddress
1380 Summit Ave 
22925 Chicago Ave 
1231445 Ross Ave Suite 1400
5671345 Philomena St 
3458110 Gatehouse Rd 

 

the slicer data sets are joined with Office address query with ID's. So my requirement is When I select 1 from slicer 1 then address should be "380 Summit Ave " and when I select 123 from slicer 2 while slicer 1 value is still selected  the adress should be "1445 Ross Ave Suite 1400"

 

  • ack2mani's avatar
    ack2mani
    Frequent Visitor
    8 years ago

    Hi MFelix I am using Card to display office addresses and above is the sample and expected output

  • MFelix's avatar
    MFelix
    Super User
    8 years ago

    Hi ack2mani,

     

    Just to understand when you have one selection on slicer 2 it should show that slicer address if you don't have any slicer it should show slicer 1 adress right?

     

    Regards,

    MFelix

  • Thejeswar's avatar
    Thejeswar
    Super User
    8 years ago

    Hi ack2mani,

     

    Please clarify something

     

    Is your data like 1 Head Office will have some Branch Offices under them?

                - If so the structure in which your table is might not be the best way to have the data to make it work the way you want.

     

    or Is there something else your head office and branch office are related? or are they completelt not related to one another?

     

    Regards,

    Thejeswar

     

    • ack2mani's avatar
      ack2mani
      Frequent Visitor
      8 years ago

      Hi Thejeswar

       

      My table consists of address of both Head Office and Branch office addresses as seperate entries. So my Concern is while slicer 1 is selected and active my slicer 2 becomes idle because table is alredy filtered based on slicer 1 value. Please suggest any better approach to acheive my goal.

      • Thejeswar's avatar
        Thejeswar
        Super User
        8 years ago

        ack2mani,

        Ya I get that your table has both Head Office and Branch Office Address as separate entities.

         

        If the Table and Slicers are going to be from the same Dataset the Slicer 2 will become blank when ever you make a selection to Slicer 1 as your entire dataset will get filtered.

         

        If showing data in the slicer 2 even when something is selected in slicer is your need, that's not a big deal. But even after soing this you will have to manually deselect the Slicer 1

         

        Instead have you Head Office ID and Branch office ID in 2 different columns and Addresses can continue to be present in the same column.

         

        Have your head office ID Column in 1 slicer and Branch Office ID in another Slicer and edit interaction such that they don't filter each other. Edit Interaction is availabe in the format section of the slicer

         

        In this case, For all the Branch Office IDs the Head Office ID will be Blank. So when ever you want to filter on Branch Office ID, select Blank in Slicer 1 which is Head Office ID and select the Sllicer 2.

         

        This way it will work fine.

         

        Regards,

        Thejeswar