Make visual count individual values , ignoring a semicolon

[Anonymous]

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 ! 

[amitchandak · Accepted solution]

@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

[Anonymous]

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 !