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
Power BI Monthly Update - September 2025
Check out the September 2025 Power BI update to learn about new features.
Fabric Community Update - August 2025
Find out what's new and trending in the Fabric community.
