Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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.
@Anonymous
Try applying trim function, also share sample data to check from my end,
Thanks,
NG
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!!!
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
User | Count |
---|---|
117 | |
73 | |
58 | |
49 | |
48 |
User | Count |
---|---|
171 | |
122 | |
60 | |
59 | |
56 |