Create a colum with groups based on a concatenated values colum

[Anonymous]

Good morning 

I've on my database a colum with some values concatenated (the values represenet different skills a person has adquired, separated by " ; ") and I would like to create, maybe a colum, or any other solution to have that values/skills separated.

What I have:

What I wan:

BUT... the skills may appear grouped at as much groups as skills has.

Example: the secind row has: Agile and Big data, so it will appear at the agile group and at the big data group.

I will be using that new group colum on a selector visual object.

Anyways, the idea is that if i filter on my visual object by a group of skills, i would like to be able to show in an other visual  object the information wich belongs to that group.

Thanks for your help.

[amitchandak · Accepted solution]

@Anonymous , Is the power query option split column data into rows can help?

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

[v-xiaoyan-msft · Accepted solution]

Hi @Anonymous ,

You can meet your needs by follwing the steps bellow：

1.Open the query editor and select the column, then click spilt column.

2.Click on the Transform column, hold down the Ctrl key on your keyboard, select the columns at the same time, and click on the Unpivot columns at the top.

3.Select the column named "Value" and click Remove Duplicate Column

4.Filter this column and uncheck (Blank). Name the new column , remove unneeded columns andclick Close & Apply in the upper left corner.

5.Back to the table view you can see the table like below:

A sample PBIX. for your reference is attached.

If I have not understood your needs correctly, please do not hesitate to inform me

Hope it helps,

Community Support Team _ Caitlyn Yan

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

[Anonymous]

I did try de split columns, but I need some more stepts after that one to create a way to agrupate the skills splited on an other place. Some ideas for that spets?

[amitchandak · Accepted solution]

@Anonymous , Is the power query option split column data into rows can help?

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/