Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to 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/
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.
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.
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?
@Anonymous , Is the power query option split column data into rows can help?
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
84 | |
69 | |
68 | |
39 | |
37 |