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.
Hello ThomasBu ,
Thank you for following up.
Kindly review the output in the attached PBIX file and let us know if everything looks good or if any modifications are needed.
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! |
Regards,
B Manikanteswara Reddy
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.