Customer Engagement & Dynamics CRM Forum

Is there a way to make Power BI report separate results lines on a multi-select field?

Example

D365 Account entity with a multi select field  for "States involved in"

The field data will look something like:
Name                    Statesinvolved in
Test Account         1; 5, 7, 10, 20    (the option set values)

I want a result set that looks like this:

Name                StatesInvolvedin

Test Account      1
Test Account       5
Test Account       7
Test Account       10
Test Account       20

------------------------------
Katie Warner
Comagine Health
Las Vegas NV
------------------------------

Hi Katie,

Yes, this is possible in Power BI. Using Power Query after that values are imported, split the column that has the comma separated values, then unpivot the other columns. Here is a short gif that walks through the steps.


Mike

------------------------------
Mike Hammons
Director, Business Intelligence
AKA Enterprise Solutions
Woodstock GA
------------------------------

Original Message:
Sent: Feb 06, 2020 03:57 PM
From: Katie Warner
Subject: Multi-select field reporting in Power BI

Is there a way to make Power BI report separate results lines on a multi-select field?

Example

D365 Account entity with a multi select field  for "States involved in"

The field data will look something like:
Name                    Statesinvolved in
Test Account         1; 5, 7, 10, 20    (the option set values)

I want a result set that looks like this:

Name                StatesInvolvedin

Test Account      1
Test Account       5
Test Account       7
Test Account       10
Test Account       20

------------------------------
Katie Warner
Comagine Health
Las Vegas NV
------------------------------