Forum Discussion

realiza's avatar
realiza
Frequent Visitor
7 years ago
Solved

Multiple Slicer Dropdown

Hi,   I have 3 slicers (region, province, town) using 1 table (having region, province, town), another slicer for issues (another table), another slicer for potentials (another table) By default, ...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi realiza 

    As tested, when change relationships from single to both,

    i can slicer the items successfully.

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi realiza 

Create relationships as below

You can download my pbix to play with.

As tested, in this way, i can filter among these slicers successfully.

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • realiza's avatar
    realiza
    Frequent Visitor
    7 years ago

    Hi Maggie, 

     

    the complete relationship is this 

     

    reg_name is region, prov_name is province

     

    Also, if I try to filter the province, region and town will follow but issues and potential will not. 

    The same if I select town. 

     

    Regards, 

    Realiza

    • v-juanli-msft's avatar
      v-juanli-msft
      Community Support
      7 years ago

      Hi realiza 

      As tested, when change relationships from single to both,

      i can slicer the items successfully.

       

      Best Regards
      Maggie

       

      Community Support Team _ Maggie Li
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.