Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (17.6k points)

I have a category multiselect field which I'm importing, which has multiple values separated by a comma:

Agriculture, Microfinance, Peace Building

My primary instinct is to split each value into a separate column using text functions, but I'm wondering if there's a better, easier way of doing this?

1 Answer

0 votes
by (47.2k points)
  • Go to Power BI and click on “edit queries”, then a new window will be opened which is also called Power Query Editor

  • Before splitting the columns, you can duplicate the column by selection “Duplicate Column” option 

  • To split the columns in the table, right-click on a column that you want to spit will open the context menu, select “split columns” and then select by “delimiter” option.

Related questions

0 votes
1 answer
asked Apr 6, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
0 votes
1 answer
asked Dec 24, 2020 in BI by Chris (11.1k points)

Browse Categories

...