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.
|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|
Solved! Go to Solution.