Split a delimited cell value in PowerBI table visual

[current_thing]

I'm creating a visual page in PowerBI. I want to create a measure that'll take:

and split it using the "|" delimeter, which would create 2 rows. How can I do this? Thank you!

[MahyarTF]

Hi,

For this purpose, you could split the column based on the Delimiter. Go to the power query, right-click on the particular column, and select Split ...

Then Enter the "|" in second field and press Ok button :

- Also you could use below DAX statement in Power Bi, when you want to create new columns :

First Col = left(Sheet22[Test - Copy], find("|", Sheet22[Test - Copy])-1)

Second Col = right(Sheet22[Test - Copy], find("|", Sheet22[Test - Copy])-1)

[current_thing]

Thanks for the response. But I need to split a concatnated string into rows within visual

[MahyarTF · Accepted solution]

After doing the steps in Power Query, you could use pivot or Unpivot in Power Query :

Select the Columns, right click on ones :

At the end delete the Unused column(s), and use the rest in your visuals in Row