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
