Forum Discussion
Automatic Filtering for Slicers
Hi Everyone, I'm working on a calculator in power bi that calculates salary increases for selected employee number (slicer), so when employee selected, the cards will shows results of calculation...
Hi SHA03 ,
Thank you for your Patience.
I somehow figured it out to get below output:
If I select employee #1003 (Charlie – Marketing – Level1), then the visual should show Charlie and Frank's Salaries (since both are in Marketing and at Level 1).
Please go through the attached pbix file.
1. Created a disconnected table with all employees
2.Created "ShowPeerEmployees"--Measure.
3.Add the ShowPeerEmployees measure as a visual-level filter, set to = 1.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!