Forum Discussion

Cathryn's avatar
Cathryn
Helper III
9 years ago

dynamic slicers selecting

Hi All

 

I was wondering if Power BI is capable of doing this.

 

I have a customer drop down field and 2 slicers - 1 for region and the other for industry.

 

If the user chooses to go straight to filtering by customer, then the slicers should reduce it's options down to the appropriate values associated with that customer.

 

So, for example, if the customer chooses frisbee perfect and the only region it exists in is USA, then France, Germany etc should disappear or grey out and USA should be selected.  The same should happen with the industry.  The industry slicers should only show the industry that it pertains to.

 

The slicers are from Industry and Region look up tables the customers are also a separte table but in the relationships its:

 

Customer(Industry) to Industry(Industry)

Customer(Region) to Region(Region)

 

How do I get the slicers to reduce the options to choose from?  Or do I need to use another visualization instead of a slicer? 

Need Help
Tips and Tricks

3 Replies

  • Cathryn's avatar
    Cathryn
    Helper III
    9 years ago

    It seems to work correctly if I use the columns within the customer table as the slicers but not the lookup tables. ??

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Microsoft Employee
      9 years ago

      Hi Cathryn,

      There should be a relationship between Customer(Industry) and Industry(Industry), and another relationship between Customer(Region) and Region(Region). Then you create two slicers, thery are influence each other.

      Please click the interactions under Format, if you turn on the button highlighted in yellow background as follows, which means one slicer will effect another one.



      Best Regards,
      Angelia

  • MFelix's avatar
    MFelix
    Super User
    9 years ago
    Hi Cathryn,

    How is your 3 fields used in the slicer linked? If you have them in the same table or in different tables correctly linked (using a relationship) addind this to your slicers it will work straight from the start when you select customer the only countries and.industries are the ones related with that customer.

    Regards,
    MFelix