Forum Discussion
Automatic Filtering for Slicers
Hi SHA03 ,
Thank you for the Response..!!
Not sure if I understood correctly for the below point mentioned by you:
"So in your example, if i filtered with an Employee No of someone in Marketing and Level 1. I'll be getting the data of all employees in Marketing and on Level 1, not just the one employee."
I was able to see the data for one employee when i filtered with an Employee No of someone in Marketing and Level 1.
Please find the screenshot for your reference:
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!
Thank you.
Hello v-venuppu
The point of the visuals is to showcase Internal Equity. So, when using the slicer (e.g., employee number), the data for the selected employee should reflect across the dashboard.
However, for the visuals that show Internal Equity, I need them to display all employees who are on the same level and in the same department as the selected employee. This helps highlight any pay variations.
This means I’m stopping the interaction between the employee number slicer and these specific visuals.
So, based on your data:
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).
This way, I can view the internal pay equity for Marketing at Level 1.
Hope I explained it clearly now.