Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 ! 

2 Replies