Forum Discussion
Solved
Split a delimited cell value in PowerBI table visual
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!
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
Thanks for the response. But I need to split a concatnated string into rows within visual
MahyarTF
Memorable Member
Memorable MemberAfter 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