Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

Filter doesn't register same values as 1 after column split

I have a file with a Name column delimiited by a comma:

 

Abby
Brandon, Abby

Charles

Charles, Brandon

 

After I column split them into different rows based on comma delimiter, I get this:

 

Abby
Brandon
Abby
Charles
Charles
Brandon

Now this is fine the way it is. But why is it that when I use the filter to filter distinct names,
Power BI doesn't see the Abby (above Brandon) and the Abby (below Brandon) as the same name?

 

1 ACCEPTED SOLUTION

@Anonymous 

Try applying trim function, also share sample data to check from my end,

Thanks,
NG

View solution in original post

3 REPLIES 3
NaveenGandhi
Super User
Super User

Hi @Anonymous 

since you use delimeter after comma, the Brandon, Abby get split and Abby has a space at the start. So trim the values to resolve this issue.

let me know if this helps.

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

Follow me on LinkedIn!!!

Anonymous
Not applicable

Sorry there are no spaces between the values. I just added it with space for clarity sake.
There is linebreak between them. Would that affect the value?
I've checked the values themselves and there are no space and linebreaks before them.

@Anonymous 

Try applying trim function, also share sample data to check from my end,

Thanks,
NG

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.