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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
newchad
Frequent Visitor

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

@newchad 

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 @newchad 

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!!!

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.

@newchad 

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

Thanks,
NG

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

August Carousel

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.