How to split column to rows in Power BI?

Question

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?

Answer 1

Split column into rows in Power BI

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

Steps:

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

---

See Also

• Group BY in Power BI
• Hide Filter Pane In Power BI