How to split text values in a column in multiple rows?

To separate text values in a column into multiple rows in Power BI, you can use the Power Query transformation feature. Follow these steps:

1. Home tab, Under, click Transform Data. This will open your POWER QUERY EDITOR. Select the column which you want to split
2. Transform tab, Text group, Click on Split Column.
3. In the menu that pops out, choose the most appropriate option for Split Column either By Delimiter, By Number of Characters or By Position, additional options are also available if you choose “By Delimiter” a dialog box will appear.
4. in that box, choose the delimiter you want to use for splitting the column. 
5. choose Split At position Under Advanced options, select Rows. 
6. Click OK.

Split By Delimiter into multiple columns

Split By Delimiter into multiple rows