Forum Discussion
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...
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:
v-ssriganesh
Community Support
Community SupportHello GabeFig,
Hope everything’s going great on your end! Just checking in has the issue been resolved, or are you still running into problems? Sharing an update can really help others facing the same thing.
Thank you.
Thank you & I apologize for not responding earlier as I was out a couple of days. I did not expect such quick response as this is my 1st time seeking help.
