Customer Engagement & Dynamics CRM Forum

Expand all | Collapse all

Multi-select field reporting in Power BI

  • 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?

    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
    ------------------------------
    The first step toward cloud success. - Migrate from CRM to D365 with expert guidance from Microsoft. I'm Ready


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

    SILVER CONTRIBUTOR
    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.

    Thanks
    Jay



    ------------------------------
    Jay Buddhdev
    https://jaybuddhdev123.wixsite.com/powerapps365
    Regina SK Canada
    ------------------------------

    The first step toward cloud success. - Migrate from CRM to D365 with expert guidance from Microsoft. I'm Ready


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

    TOP CONTRIBUTOR
    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.

    Power BI split multiselect tableMight need to click the image to see the animation.

    Mike

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

    The first step toward cloud success. - Migrate from CRM to D365 with expert guidance from Microsoft. I'm Ready


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