Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Splitting multiple columns by delimeter

Hi there

 

So I have a column in my dataset called 'Tags' which contains multiple values. I can split by delimiter to create multiple tag columns which has the tag name and value separated by a colon e.g. Environment:Dev

There could be any number of tags in the dataset so the number of Tag columns, once split, could change each time the report refreshes. 

Is there anyway I can split all these columns into two new columns of tag name and tag value without splitting each column by delimiter?

Need Help
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hi, Anonymous 

     

    Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

    Table:

     

    You need to make 'List' column selected, click 'Split Column'=>'By Delimiter', set as below.

     

    Then you may make 'List' column selected, click 'Split Column'=>'By Delimiter', set as below.

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

3 Replies