How to split column to rows in Power BI?

Question 1

In Power BI, how do I split a row by a delimiter to extract specific values or create new rows based on the delimited data?

Example: Let's say I have a column named "Country" with multiple values like "USA, UAE" separated by a comma. How can I split this column into two separate rows using a comma as the delimiter in Power BI?

Question 2

Split column into rows in Power BI

To split a column into multiple rows in Power BI, you have to do the following:

Steps:

Open Power BI Desktop, from the Home tab, and click on Transform Data.
In Power Query, select your query,
Then click on "Split Column"> then select "By Delimiter" as stated below.
Select your delimiter, or use a Custom to specify your delimiter as per your need.
Click on "Advanced Options", then check "Rows"
Click OK, to get your column split into rows as shown below.

Split column into rows in Power BI

To split a column into multiple rows in Power BI, you have to do the following:

Steps:

Open Power BI Desktop, from the Home tab, and click on Transform Data.
In Power Query, select your query,
Then click on "Split Column"> then select "By Delimiter" as stated below.
Select your delimiter, or use a Custom to specify your delimiter as per your need.
Click on "Advanced Options", then check "Rows"
Click OK, to get your column split into rows as shown below.