Forum Discussion

Cathryn's avatar
Cathryn
Icon for Helper III rankHelper 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 ...
Need Help
Tips and Tricks
Cathryn's avatar
Cathryn
Icon for Helper III rankHelper 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
    Icon for Microsoft Employee rankMicrosoft 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