Forum Discussion

GabeFig's avatar
GabeFig
Frequent Visitor
1 year ago
Solved

Break out Multi-Select field into Slicer

The (2) images on the left are what the data looks like in the software that is being exported into MS BI. MS BI is interpreting them as shown in the right image. The Slicer for both the Ca...
  • v-ssriganesh's avatar
    v-ssriganesh
    1 year ago

    Hello GabeFig,
    Thanks for sharing the sample data.

    I have reproduced your scenario using the sample data you shared and implemented the required filtering logic based on multi-valued Categories and Features columns (with delimiters like ;).

    Output:

    • When “Application” is selected from the Categories slicer:
      You will see only rows where “Application” is one of the multiple categories.


    • When “AI-Enabled” is selected from the Features slicer:
      You will see only rows where “AI-Enabled” is one of the feature values.

    For your reference, I’m attaching the .pbix file.

    Best regards,
    Ganesh Singamshetty

v-ssriganesh's avatar
v-ssriganesh
Icon for Community Support rankCommunity Support
1 year ago

Hi GabeFig,
Thanks again for the follow-up and the screenshot.

To better assist you, could you please provide sample data that fully reflects the issue? Kindly share the data in a usable format (such as Excel or a simple table), not as a screenshot. The sample should:

  • Clearly show the structure you're working with
  • Include enough data to replicate the issue
  • Exclude any sensitive or unrelated information
  • Include the expected result/output based on that data

If you're unsure how to provide data in the forum, please refer to this helpful guide:
How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Once we have that, I’ll be happy to help you resolve it.

Best regards,
Ganesh Singamshetty

GabeFig's avatar
GabeFig
Frequent Visitor
1 year ago
Record ID#Software/ServiceCategoriesFeatures
705ZoominfoUnknownUnknown
498Zoom Outlook add-inUnknownAI-Enabled
559ZoomCloudAI-Enabled;Communication
707ZkipsterUnknownUnknown
997World Trademark ReviewIP Management;Legal & Market ResearchUnknown
998World Intellectual Property ReviewIP Management;Legal & Market ResearchUnknown
843Working AdvantageUnknownUnknown
589Work Management SystemApplication;CloudUnknown
459WordRakeUnknownUnknown
277WordApplication;BusinessUnknown
999Women's Wear DailyLegal & Market ResearchUnknown
557Windows OSApplication;CommercialUnknown
452WinDJViewUnknownUnknown
995Win RemoteBusinessUnknown
1003Washington Business JournalLegal & Market ResearchUnknown
851Walkingspree AppApplicationUnknown
1006VitalLawLegal & Market Research;Legal EducationUnknown
948Vault VerifyAutomationUnknown
961ValimailRegulatory & ComplianceUnknown
590Vacation Reporting ToolUnknownUnknown
910V Drive File ShareCollaboration & CommunicationUnknown
423USDHS Check RequestsApplication;CloudUnknown
1007USCIS Policy ManualLegal & Market ResearchUnknown
945U Drive File ShareCollaboration & CommunicationUnknown
954TritechCollaboration & CommunicationUnknown
884Trexo GlobalIP ManagementUnknown
980Travelling CoachesLegal EducationUnknown
1014Trademark NavigatorLegal & Market ResearchUnknown
580Ticket TrackerApplication;CloudUnknown
988Threat ManagerRegulatory & ComplianceUnknown
1002The Washington PostLegal & Market ResearchUnknown
1036The Kluwer IP Law ManualIP Management;Legal & Market ResearchUnknown
588Task Management SystemApplication;CloudUnknown
909T Drive File ShareCollaboration & Communication;Project ManagementUnknown
601Synchronizer PlayerUnknownUnknown
717Symphony Web Services AdminUnknownUnknown
798SwoogoUnknownUnknown
1063Supreme Court BriefLegal & Market ResearchUnknown
759SupabaseUnknownUnknown
708SunIPUnknownIP Management;Legal Analysis & Strategy
  • GabeFig's avatar
    GabeFig
    Frequent Visitor
    1 year ago

    Ganesh

     

      Thank you so very much!

      I believe I have got the BI showing as requested.

      Your patience is above and beyond!

     

     Gabe

     

     

  • v-ssriganesh's avatar
    v-ssriganesh
    Icon for Community Support rankCommunity Support
    1 year ago

    Hello GabeFig,
    Thanks for sharing the sample data.

    I have reproduced your scenario using the sample data you shared and implemented the required filtering logic based on multi-valued Categories and Features columns (with delimiters like ;).

    Output:

    • When “Application” is selected from the Categories slicer:
      You will see only rows where “Application” is one of the multiple categories.


    • When “AI-Enabled” is selected from the Features slicer:
      You will see only rows where “AI-Enabled” is one of the feature values.

    For your reference, I’m attaching the .pbix file.

    Best regards,
    Ganesh Singamshetty