Reply
WalidHussein00
Regular Visitor
Partially syndicated - Outbound

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?

 

 

 

 

3 REPLIES 3
Ashish_Mathur
Super User
Super User

Syndicated - Outbound

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/

Syndicated - Outbound

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/
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)