The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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?
Solved! Go to Solution.
@newchad
Try applying trim function, also share sample data to check from my end,
Thanks,
NG
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
108 | |
82 | |
77 | |
46 | |
39 |
User | Count |
---|---|
137 | |
108 | |
64 | |
64 | |
53 |