• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Slicer and Data Validation


New Member
Hi, I am creating a job leveling matrix and my dashboard is filtered using a slicer. I had to add in 4 data validation list in the dashboard that are associated with the job codes that are filtered in the dashboard. How can I make selections from my drop down list and not lose the values when filter the data? I want the data selected from the drop downs to keep its values and filter with the data from the slicer.
Last edited:
Attaching an example file for reference. Any help and tips would be greatly appreciated.


  • EXAMPLE Human Resources Job Leveling Matrix.xlsm
    78.3 KB · Views: 7