Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello All,
I have the following values.
Car Brand |
Audi A4 |
Audi Q4 |
BMW iX3 |
Ford Focus |
When I upload it into power bi, it shows a white space.
However I am unable to extract the text before delimiter. I copied paste the value into a note pad and there is indeed a delimiter.
Any idea how I could manage to split it by the white space.
The end result would look like this:
Car Brand | Model |
Audi | A4 |
Audi | Q4 |
BMW | iX3 |
Ford | Focus |
Thanks,
Chris
Solved! Go to Solution.
Hi @Chrisjr
I'm not sure what the delimiter is from your screenshot. But you may try the Split Column feature in Power Query Editor. Select the "Car Brand" column, split it through Home > Split Column > By Delimiter. Split columns by delimiter - Power Query
If Power Query can tell the delimiter, it will display the delimiter in the input box beneath "Select or enter delimiter" automatically. If it is a special character, it will select the checkbox "Split using special characters" in "Advanced options". If it doesn't tell the delimiter correctly, you can expand the dropdown box to try other special characters.
Hope this helps.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi @Chrisjr
I'm not sure what the delimiter is from your screenshot. But you may try the Split Column feature in Power Query Editor. Select the "Car Brand" column, split it through Home > Split Column > By Delimiter. Split columns by delimiter - Power Query
If Power Query can tell the delimiter, it will display the delimiter in the input box beneath "Select or enter delimiter" automatically. If it is a special character, it will select the checkbox "Split using special characters" in "Advanced options". If it doesn't tell the delimiter correctly, you can expand the dropdown box to try other special characters.
Hope this helps.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
99 | |
76 | |
67 | |
61 |
User | Count |
---|---|
142 | |
106 | |
103 | |
85 | |
70 |