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.