Forum Discussion
Multiple Entries
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
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 - SQLBIThank you very much for your prompt response. I will let you know of outcome when I complete
Option proposed worked for us. Thank you very much
