Hi,
we will have 2 different columns one with the Primary email id and another column with multiple email id's of the same person(the reason for multiple email id's is a contingent employee with one email id and once the contingent employee becomes a permanent employee the email id will be changed) so basically, employees both emails are being tracked in our database.
Now, in the slicer when we search for an employee we need see all the email id's. but when we select the employee email we need to display only the primary email id as per below snapshot.
Can any one help with how can se implemented
| Primary Email id | Multiple Email id's |
| Kaul, Sheetal <sheetal.kaul@hpe.com> | Kaul, Sheetal <sheetal.kaul@hpe.com>,<kaul@hpe.com> |
| Menon, Sheetal <sheetal.menon@hpe.com> | Menon, Sheetal <sheetal.menon@hpe.com> |
| R, Sheetal <sheetal.r@hpe.com> | R, Sheetal <sheetal.r@hpe.com>, <reena.s@hpe.com> |
| Katke, Sheetal <sheetal.katke@hpe.com> | Katke, Sheetal <sheetal.katke@hpe.com>,<talk@hpe.com>,<katke@hpe.com> |
Helpful resources
Join our Fabric User Panel
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Power BI Monthly Update - February 2026
Check out the February 2026 Power BI update to learn about new features.
