Forum Discussion

Jayprekk's avatar
Jayprekk
Helper I
8 months ago
Solved

To create a filter using comma separated field.

Hi,

I need to pull data from a field (with comma separated values). This field continue to have new values added when new incidents are recorded into the DP table. I need it to be uniquely shown in the drop down list and be able to select multiple options. Based on my delection, it should filter the data from the DP table. I have added a image depicting this. I I have tried looking in the existing solutions but was unable to find the right solution.

 

Need Help

9 Replies

    • Jayprekk's avatar
      Jayprekk
      Helper I
      7 months ago

      Thank you Amit for the wonderful video. As my dataset was big, this approach was the best for me. Thanks again. Apologies for the late reply as I was travelling. Thanks

  • rohit1991's avatar
    rohit1991
    Super User
    8 months ago

    Hii Jayprekk 

     

    Power BI cannot filter comma-separated values directly, so the correct solution is to split the tags into rows. In Power Query, use Split Column >> By Delimiter >> Comma >> Split into Rows to normalize the Security Tags field. This creates a proper one-tag-per-row table that you can use as a slicer. When the user selects “Bus,” Power BI will correctly return records like 1111 and 2222 because they now have a real relational match instead of text search.

  • v-hashadapu's avatar
    v-hashadapu
    Community Support
    8 months ago

    Hi Jayprekk , hope you are doing great. May we know if your issue is solved or if you are still experiencing difficulties. Please share the details as it will help the community, especially others with similar issues.

  • v-hashadapu's avatar
    v-hashadapu
    Community Support
    8 months ago

    Hi Jayprekk , 

    Hope you're doing okay! May we know if it worked for you, or are you still experiencing difficulties? Let us know — your feedback can really help others in the same situation.