Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear Power BI Community
We have a table and one column has multiple entries (name of nurse) per row, as per 1st screenshot below. When we filter per name the selection, as in the 2nd screenshot, “Project site lead nurse” includes all names involved/with the same title affiliated with the selected name. How can we create a filter that will have as a result only one individual name and not multiple names, when we search for it.
kind regards
Trish Boateng
Solved! Go to Solution.
@TrishB01 , based on what I got so far , you have split this column into rows in power query
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
Of you can try Text filter
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381309?src=office&tab=Overview
Further to @amitchandak once you split your column into rows in power query you might want to further shape the data into a many to many relationship with a bridge table:
Many-to-many relationships in Power BI and Excel 2016 - SQLBI
Thank you very much for your prompt response. I will let you know of outcome when I complete
@TrishB01 , based on what I got so far , you have split this column into rows in power query
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
Of you can try Text filter
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381309?src=office&tab=Overview
Option proposed worked for us. Thank you very much
Thank you very much for your prompt response. I will let you know of outcome when I complete
Further to @amitchandak once you split your column into rows in power query you might want to further shape the data into a many to many relationship with a bridge table:
Many-to-many relationships in Power BI and Excel 2016 - SQLBI
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |