Forum Discussion

current_thing's avatar
current_thing
Frequent Visitor
4 years ago
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!
Need Help
  • MahyarTF's avatar
    MahyarTF
    4 years ago

    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

     

MahyarTF's avatar
MahyarTF
Icon for Memorable Member rankMemorable Member
4 years ago

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's avatar
    current_thing
    Frequent Visitor
    4 years ago

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

    • MahyarTF's avatar
      MahyarTF
      Icon for Memorable Member rankMemorable Member
      4 years ago

      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