Forum Discussion
Cathryn
9 years agoHelper III
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 ...
Cathryn
9 years agoHelper III
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
9 years agoMicrosoft Employee
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