Relative Content

Tag Archive for powerbipowerquerydata-modeling

Splitting columns containing multiselect answers separated by semicolons – in the Stack Overflow 2023 survey

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?