Forum Discussion
Filter a table based on a variable factor
So I finally made it thanks to your input though not directly but with a decent workaround.
I could not create a seperate virtual table as I was hoping for but the File from Anonymous showed me another way. I simply put 2 slicers on the same page. The slicer for the employee ID is connected to the individual values shown and the second slicer is connected to the visuals. I used the chiclet slicer and used the forced selection (on the grade for the employee) and adjusted the formating so it is not visible as a slicer and blends in.
Thanks for your effort, highly appreciated! It is not yet working unfortunately. The page 2 selects only the highest grade. It seems to me that the allselect function doens't work with the slicer. I adjusted the File slightly and put the Employee ID in the slicer and a card with the grade per valuelookup. This grade should filter then the table on the second page but I can't get this working so far.
Here is the link to the one drive or a screenshot if you don't want to open the ink.
So I finally made it thanks to your input though not directly but with a decent workaround.
I could not create a seperate virtual table as I was hoping for but the File from Anonymous showed me another way. I simply put 2 slicers on the same page. The slicer for the employee ID is connected to the individual values shown and the second slicer is connected to the visuals. I used the chiclet slicer and used the forced selection (on the grade for the employee) and adjusted the formating so it is not visible as a slicer and blends in.