Forum Discussion

Medha12's avatar
Medha12
Advocate I
8 years ago

Power BI Slicer Issue

Hi All, I am facing an issue in Power BI where there are two slicers and the user can use any one to filter the report. Consider, Slicer 1 - Employee Name and Slicer 2 - Employee ID Employee Name ...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

Hi Medha12,

If you want to the slicer impact each other, the Employee Name and Employee ID should be located in a same table or two different table with relationship. So in your scenario, if the user opts for Employee Name and selects 'ABC', then the Employee ID slicer visual should auto populate to 1 and so on, you should create a new table including both [Employee Name] and [Employee ID] column, create a relationship between tables, which lead to ABC point to ID 1.

Thanks,
Angelia