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.
Thank you! The table is indeed being created but only for the maximum grade. It seems the first step is not properly working yet. When I put the calculation in a card, it shows me the correct results. Inside the table view however, it gives only blanks. Therefore the second step, gives me only the rows for the maxium grade I think. What am I missing?
Hi ThomasBu ,
Thank you for reaching out to Microsoft Fabric Community Forum.
johnbasha33 Thank you for your quick response.
ThomasBu could you please share the expected result or a sample output you're aiming for? That would help a lot in providing a more accurate solution.
👉 Please make sure not to include any sensitive or confidential data in the sample.
Also, if the issue has already been resolved, we'd really appreciate it if you could share the steps that worked for you ,it might help others facing the same problem. And if a reply helped solve it, please consider marking it as a solution so it benefits the wider community.
Regards,
B Manikanteswara Reddy
Thanks for reaching out. Please see below what I am aiming for. Per selected slicer it should lookup the corresponding grade in the employee list (already working). Then a new table should be created filtering all employees within this grade from the employee list. Based on this (dynamic) table, I want to create statistical charts based on all these filtered value. Data needs to automatically refresh once the slicer is chosen/changed. Hope that helps If anything was unclear (data is fictious for testing of course).
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