dynamic slicers selecting

[Cathryn]

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? 

[MFelix]

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

[Cathryn]

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]

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