Forum Discussion
Break out Multi-Select field into Slicer
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- When “Application” is selected from the Categories slicer:
Community SupportHi GabeFig,
Thanks again for your detailed follow-up and for sharing the screenshot.
What you're seeing with the "Business" category behaving differently is due to how Power BI handles split-to-rows transformations on delimited text. When a category like "Application; Business" is split, Power BI creates separate rows one with "Application", and another with "Business". However, "Business" also appears as a standalone value in other rows, which may result in multiple "Business" values in your slicer or inconsistent filtering behavior.
To make sure the "Business" category filters all relevant rows whether it appears alone or with others. We suggest the following steps:
Duplicate your main table and name it CategoryMapping.
- Keep only ID and Categories columns and Split Column by Delimiter >> choose ; and split into rows.
- Trim whitespace from the split column to clean up any extra spaces and rename the new column to Category then Remove duplicates so that "Business" appears only once per ID.
- Create a relationship between CategoryMapping[ID] to MainTable[ID] and Use CategoryMapping[Category] in your slicer.
If the issue persists try to share your sample data: How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Best Regards,
Ganesh singamshetty.
The CategoryMapping & FeatureMapping look great but again if 'application' is selected it will show only those that have just 'application'.
If the item has 'application; cloud' then that will not show.
If 'application' & 'cloud' are chosen then only those that have either 'application' or 'cloud' but not those that have 'application; cloud'.
The problem seems to be the Manage Relationship' I've tried several if not all variations.
It seems best to use the Categories field cause if the Records ID# is used it only returns (1) as w/ the Feature
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
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 CommunityOnce we have that, I’ll be happy to help you resolve it.
Best regards,
Ganesh Singamshetty Record ID# Software/Service Categories Features 705 Zoominfo Unknown Unknown 498 Zoom Outlook add-in Unknown AI-Enabled 559 Zoom Cloud AI-Enabled;Communication 707 Zkipster Unknown Unknown 997 World Trademark Review IP Management;Legal & Market Research Unknown 998 World Intellectual Property Review IP Management;Legal & Market Research Unknown 843 Working Advantage Unknown Unknown 589 Work Management System Application;Cloud Unknown 459 WordRake Unknown Unknown 277 Word Application;Business Unknown 999 Women's Wear Daily Legal & Market Research Unknown 557 Windows OS Application;Commercial Unknown 452 WinDJView Unknown Unknown 995 Win Remote Business Unknown 1003 Washington Business Journal Legal & Market Research Unknown 851 Walkingspree App Application Unknown 1006 VitalLaw Legal & Market Research;Legal Education Unknown 948 Vault Verify Automation Unknown 961 Valimail Regulatory & Compliance Unknown 590 Vacation Reporting Tool Unknown Unknown 910 V Drive File Share Collaboration & Communication Unknown 423 USDHS Check Requests Application;Cloud Unknown 1007 USCIS Policy Manual Legal & Market Research Unknown 945 U Drive File Share Collaboration & Communication Unknown 954 Tritech Collaboration & Communication Unknown 884 Trexo Global IP Management Unknown 980 Travelling Coaches Legal Education Unknown 1014 Trademark Navigator Legal & Market Research Unknown 580 Ticket Tracker Application;Cloud Unknown 988 Threat Manager Regulatory & Compliance Unknown 1002 The Washington Post Legal & Market Research Unknown 1036 The Kluwer IP Law Manual IP Management;Legal & Market Research Unknown 588 Task Management System Application;Cloud Unknown 909 T Drive File Share Collaboration & Communication;Project Management Unknown 601 Synchronizer Player Unknown Unknown 717 Symphony Web Services Admin Unknown Unknown 798 Swoogo Unknown Unknown 1063 Supreme Court Brief Legal & Market Research Unknown 759 Supabase Unknown Unknown 708 SunIP Unknown IP Management;Legal Analysis & Strategy - v-ssriganesh
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 - When “Application” is selected from the Categories slicer: