cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NPV32
Helper I
Helper I

Limit Slicer Criteria

Hello,

 

I have a data set which includes various employees who are no longer with the company. I am filtering my visual by employee, and would like to have only active employees in the slicer criteria.

 

I have tried filtering the data set, and the filtered employees continue to show in the slicer criteria. 

I don't want to delete the data of the old employees, in case I need to reference in the future. 

 

Any suggestions?

1 ACCEPTED SOLUTION
DoubleJ
Responsive Resident
Responsive Resident

You could set up a report wide Filter that filters the inactive emplyoees. That way these emplyoees will not appear in the slicer or any other visual but are still there if you need them in the future.

 

pbi.png

 

Hope this helps!

JJ

View solution in original post

2 REPLIES 2
DoubleJ
Responsive Resident
Responsive Resident

You could set up a report wide Filter that filters the inactive emplyoees. That way these emplyoees will not appear in the slicer or any other visual but are still there if you need them in the future.

 

pbi.png

 

Hope this helps!

JJ

View solution in original post

Perfect! Thank you for your help.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.