- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Splitting columns containing multiselect answers separated by semicolons - in survey dataset
Currently, I am practicing my Power BI skills using the **latest Stack Overflow survey dataset**. In the dataset, multiple columns contain multi-select answers separated by semicolons. I need to extract this data for further analysis. I used the *'split columns into rows' technique*, which caused the number of rows to increase dramatically. Additionally, how can I structure my data model in Power BI in terms of fact and dimension tables?
Currently, when I try to split each column by its semicolon-separated values, I cannot load the dataset into Power BI, and the results are not correct. How can I deal with these columns? Should I separate them from the main fact table? What are the right steps to use these multi-select columns?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi,
Share some data to work with and show the expected result. Share data in a format that can be pasted in an MS Excel file.
Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Why have you shared 4 files? Why have you shared such a heavy file. Share a small sample file and for that sample, show the expected result in another tab.
Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
09-06-2024 08:12 AM | |||
02-06-2024 06:08 AM | |||
02-26-2024 02:33 PM | |||
02-19-2024 07:51 AM | |||
11-28-2024 07:21 AM |
User | Count |
---|---|
141 | |
115 | |
84 | |
63 | |
48 |