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.
Hi,
We have a field with a list that we want to show in Power BI.
Example field:
A dimension1;dimension2
B dimensionA;dimensionB;dimensionC
Result should be something like:
A dimension1
dimension2
B dimensionA
dimensionB
dimensionC
Can somebody help me out with that?
Our can help me with another solution.
Thanks,
Davina
Solved! Go to Solution.
Hi Davina,
Theres a couple of options.
Option 1
If you go to the query editor and select Split Column by Delimiter as shown:
Split Column
Choose to split by the Semi Colon if it isnt already selected
Split Column
Select the Category Column as shown, then choose Unpivot Other Columns.
Unpivot
The 'Category' and 'Value' columns show the information you requested.
Review
Option 2
Alternatively, another option is to use the 'Replace Values' command.
Select the Values Column, then choose 'Replace Values' to replace the semicolon with a Carriage Return and Line Feed.
Replace delimiter with Carraige Return and Line Feed
This will provide the data as shown if this is preferable.
Redults
Hopefully this answers your question @Anonymous - Its the first one i've answered on this forum so would appreciate if you could let me know.
Cheers,
Richard
@Anonymous , In Data Transformation/Edit Query mode, You can split a column by Delimiter, Use Split into rows
Refer for steps
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
Hi Davina,
Theres a couple of options.
Option 1
If you go to the query editor and select Split Column by Delimiter as shown:
Split Column
Choose to split by the Semi Colon if it isnt already selected
Split Column
Select the Category Column as shown, then choose Unpivot Other Columns.
Unpivot
The 'Category' and 'Value' columns show the information you requested.
Review
Option 2
Alternatively, another option is to use the 'Replace Values' command.
Select the Values Column, then choose 'Replace Values' to replace the semicolon with a Carriage Return and Line Feed.
Replace delimiter with Carraige Return and Line Feed
This will provide the data as shown if this is preferable.
Redults
Hopefully this answers your question @Anonymous - Its the first one i've answered on this forum so would appreciate if you could let me know.
Cheers,
Richard
This also resolved my issue in this post: https://community.powerbi.com/t5/Desktop/Separate-products-that-are-listed-in-data-with-or/m-p/23621... Thank you!!
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 |