Forum Discussion

kapil512's avatar
kapil512
Helper II
8 years ago
Solved

How to split the the Column into Multiple rows.

Hi,   Can you please helpw me out in this, i am trying snce two days.   I want to split the column data into different rows with same data.   Example: Column1|Comun2|Comun3|Column4| Data: 1|ka...
  • TomMartens's avatar
    TomMartens
    8 years ago

    Hey,

     

    in the query editor, I just marked the column and from the context menu of the marked column I chose "Split Coliumn" -> "By Delimiter"

     

    From the dialog I chose Advanced Options as shown below

     

    This leads to the following result

     

    Hope this is what you are looking for

     

    Regards

    Tom

     

TomMartens's avatar
TomMartens
Super User
8 years ago

Hey,

 

I guess it would be really helpful if you could share a pbix, please start a thread, you may call is "Stacked column chart".

 

Regards

Tom

kapil512's avatar
kapil512
Helper II
8 years ago

Thank you Tom.

 

I will do that.