Hi,
Hope you can help. Is it possible to hide a certain selection on the slicer? Basically I want to hide data on the graph on where the department has left than 5 employees?
Thanks
Hi,
Hope you can help. Is it possible to hide a certain selection on the slicer? Basically I want to hide data on the graph on where the department has left than 5 employees?
Thanks
Hi sansan,
Can you create a helper column that gives a blank when Employees is less than 5? Then do your slicer on this and use Slicer Settings to Hide rows with no data? See the attached.
Slicer Helper Hide no data.xlsx
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
You forgot to place the sample file
Hi Vraag,
Click on the "Slicer Helper Hide no data.xlsx" and it should be there. I've just learned how to attach files a little quicker.
Thanks, but slicers is links to several pivots table, not sure if this will work?
Thanks, hide with no data would only work if no data right?
Yep, but that is why I built a helper column and an If() formula in it to go to "No Data" if the Employees were less than 5. Use this helper column instead of the real column in your slicer.
Thanks, I guess you built the helper on the master data? I will try this out and let you know. Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks