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

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

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