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 they have encountered, some people tick more than 1 box . This is what it looks like on the graph provided by Ms Forms :
And this is what it looks like in excel :
When I drag and drop it into Power BI , it doesn't ignore the semicolon , like the MS Forms , and just shows this :
Any idea what the solution might be ?
Thank you !
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
2 Replies
- amitchandak
Super User
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
- AnonymousNot applicable
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 !