Customer Engagement & Dynamics CRM Forum

 View Only
  • 1.  Multi-select field reporting in Power BI

    Posted Feb 06, 2020 03:58 PM

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


    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

  • 2.  RE: Multi-select field reporting in Power BI

    Posted Feb 06, 2020 05:01 PM
    Hi Katie,

    By using the new feature of the Power BI you can multi-select data element on visuals, you can now select more than one data point in Power BI Desktop report page, and highlight the results across the visuals on the page. To multi-select data points in visuals, simply use CTRL+Click to select multiple data points. See below screen capture for multiple data points select on visual(multi-select):

    Please let me know if you have any questions/concerns.


    Jay Buddhdev
    Regina SK Canada

  • 3.  RE: Multi-select field reporting in Power BI

    Posted Feb 10, 2020 09:43 AM
    Edited by Mike Hammons Feb 10, 2020 09:44 AM
    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.

    Might need to click the image to see the animation.


    Mike Hammons
    Director, Business Intelligence
    AKA Enterprise Solutions
    Woodstock GA

If you've found this thread useful, dive deeper into User Group community content by role