How to Split Columns in Power BI

0 votes
Can anyone demonstrate how to split columns in an existing table in Power BI  using a Query editor?
Feb 4, 2020 in Power BI by Roshni
• 10,480 points
898 views

1 answer to this question.

0 votes

Splitting columns in Power BI using the Query Editor is a common operation when you need to separate data within a column into multiple columns. Here's a step-by-step demonstration:

Step 1: Open Power BI and Load Data

  1. Open Power BI Desktop.
  2. Load your data into the Power BI file.

Step 2: Access Query Editor

  1. In the Home tab, click on "Transform Data." This opens the Query Editor.

Step 3: Select Column to Split

  1. In the Query Editor, select the column you want to split.

Step 4: Navigate to the "Split Column" Option

  1. With the column selected, go to the "Transform" tab.
  2. Click on "Split Column," and then choose "By Delimiter."

Step 5: Choose the Delimiter

  1. In the "Split Column by Delimiter" window, choose the delimiter that separates your data. This could be a comma, space, or any other character.
  2. You can also specify the maximum number of columns to create if your data has a variable number of items separated by the delimiter.

Step 6: Review the Changes

  1. After splitting, you will see the original column divided into multiple columns in the preview pane.
  2. Adjust column names and data types as needed.

Step 7: Confirm Changes

  1. Click "OK" to apply the changes.

Step 8: Close and Apply

  1. Close the Query Editor.
  2. Power BI will prompt you to apply the changes. Click "Apply Changes."

Step 9: Check the Results

  1. Go back to the main Power BI interface and review your updated table.

That's it! You've successfully split a column using the Query Editor in Power BI. Keep in mind that these steps might vary slightly depending on the version of Power BI you are using, but the overall process remains similar.

Ready to revolutionize your data skills? Explore our dynamic Power BI Course Syllabus designed to empower you with in-depth knowledge and practical expertise.

Also Read:

Also Read:

How can I retrieve distinct values from multiple columns using Power BI?

answered Jan 6 by anonymous
• 1,420 points

Related Questions In Power BI

0 votes
1 answer

How to combine your data or tables in Power BI?

Power BI includes Query Editor which is ...READ MORE

answered Feb 27, 2019 in Power BI by Phalguni
• 1,020 points
2,914 views
0 votes
1 answer

How to Install Power BI in Windows

Hi, Anitha Go to this Link https://powerbi.microsoft.com/en-us/downloads/ Then click on ...READ MORE

answered Feb 28, 2019 in Power BI by Cherukuri
• 33,030 points
1,070 views
0 votes
3 answers

How to create final table based on Joins of two tables in power BI?

To do so, follow these steps: From the ...READ MORE

answered Dec 16, 2020 in Power BI by Gitika
• 65,770 points
56,024 views
+2 votes
3 answers

How to replace null values with custom values in Power BI(power query editor)?

Hi Nithin, To fill or replace the null or ...READ MORE

answered Mar 8, 2019 in Power BI by Cherukuri
• 33,030 points
159,983 views
+1 vote
1 answer

display the count of rows matching some criteria

Do you want to show a table ...READ MORE

answered Aug 5, 2019 in Power BI by anonymous
• 33,030 points
1,320 views
0 votes
3 answers

How to add an extra column to the existing table in power bi query editor?

Click on edit queries after loading source ...READ MORE

answered Dec 16, 2020 in Power BI by Roshni
• 10,480 points
79,015 views
0 votes
1 answer

How to demote Headers in Power BI query editor?

Hi, There are the steps which you can ...READ MORE

answered Feb 3, 2020 in Power BI by Jitesh
19,225 views
0 votes
1 answer

How to trim space from Power BI?

Hey, Make sure your column type is set ...READ MORE

answered Feb 6, 2020 in Power BI by Gitika
• 65,770 points
12,133 views
0 votes
1 answer

How to show a color bar even when no value is present or value is 0?

To display a color bar even when ...READ MORE

answered 3 days ago in Power BI by anonymous
• 1,420 points
644 views
+2 votes
1 answer

How to create measure out of column

To convert the LossValue column into a ...READ MORE

answered Apr 29 in Power BI by anonymous
• 1,420 points
951 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP