Filter issue

[RanjanThammaiah]

Hi All,

I am not sure this could be done in the Power Bi.

I just relating my quarrey to the excel.

I have the column with the multiple values which are seperated by coma.

Below is my filter example. if i select "Agile Business FM" it should give all the results of that name contains, in excel i have the macro to run the search the names in this columns to get the fields that i selected in the filter.

Do we have something similar to do the same in the Power bi. i want this filed to add in the filter. it should show the individual fields.

Row Labels

Agile Business FM,Agile Business GRC,SCR

Agile Business FM,Agile Business Trans,SCR

Agile Business FM,SCR

Agile Business FM,TFO - GSA Tag,SCR

Agile Business GRC,SCR

Agile Business GRC,SCR,GPS Dynamic Defense

Agile Business People,SCR

Agile Business SCM,SCR

Regards,

Ranjan

[Anonymous · Accepted solution]

Hi RanjanThammaiah,

You can refer the below URL to get this resolved.

https://social.technet.microsoft.com/Forums/en-US/71b0d4cb-e2d1-47f3-a1ef-3e0a47bac4f7/transform-com...

Regards,

Pradeep