Forum Discussion
LF
3 years agoFrequent Visitor
Filter/ Dax
How can I Filter my rows with multiple data separated by a comma? My issue is if I clean the data in Power query. The rest of my columns are inaccurate, as values are added to match the multiple valu...
amitchandak
3 years agoSuper User
LF , One way is to split the values into rows in the table.
Another one is to split values into rows in a new dimension. The second one keeps the fact clear
Power BI- Text Part slicer to filter/search text - https://youtu.be/MKKWeOqFG4c
https://medium.com/@amitchandak/power-bi-search-text-parts-in-text-ad2f9783ffa2