Forum Discussion
Make visual count individual values , ignoring a semicolon
Hi there I hope there is a solution to this. I don't know how to make PowerBI to ignore a character in a cell and count individually. So : There is a form where people mention what th...
Anonymous , Option one- use split by a delimiter in power query and create additional rows
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
or try
Power BI- Text Part slicer to filter/search text - https://youtu.be/MKKWeOqFG4c
amitchandak
Super User
Super UserAnonymous , Option one- use split by a delimiter in power query and create additional rows
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
or try
Power BI- Text Part slicer to filter/search text - https://youtu.be/MKKWeOqFG4c
Thank you amitchandak , I have used the 1st method . I have duplicated the column that had all the complicated data , and then I have split it by rows , and it works now .
Cheers !