Forum Discussion
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 Employee ID
ABC 1
XYZ 2
If the user opts for Employee Name and selects 'ABC', then the Employee ID slicer visual should auto
populate to 1 and so on.
Can anyone please help me out on this?
Thanks,
Medha
3 Replies
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,
AngeliaHi Angelia,
The two columns are from two different tables and there is a relationshiop between them.
When I select manually Employee Name 'ABC' , the second slicer filters down to 1 but I have to manually go to the slicer and select '1' ; instead of manually selecting, I want that slicer to automatically display '1' (just like a Card visual displays it without having to manually go and select the value).Thanks,
Medha
Hi Medha12,
Up to date, your requirement is unsupported, there are following similar ideas, please review and vote them. You can also create a new idea there.Based on Selections in slicers, items within slicers should automatically move at the top of the list
Slicer base on column base on slicerBest Regards,
Angelia
