Contains Filter issue

[Anonymous]

Hi All,

I have these values in a column in a table

AEP
AEP
AEP,AO
AEP,AO,SQI
AEP,SQI
AO
AO,SQI
SQI

From this I have created a slicer in power BI using "contains" which has the follwing values

AEP
AO
SQI

My issue:

     i) When I select  "AEP" in the slicer, all related values should appear ex: AEP, (AEP,AO), (AEP,SQI).... should appear ,

       but when i  deselect  "AEP" ,only AEP should be removed and rest all values associated with it should appear.

similarly AO and SQI values should behave.

@v-syr @v-xul 

Thanks in Advance!

[v-easonf-msft]

Hi， @Anonymous 

I am afraid that it cannot be achieved at present.

Powerbi cannot obtain the status of your last step. Each change of the selected state is compared with the unselected state of the slicer and you cannot compare the last selection state of the slicer with the current selection state.

Best Regards,
Community Support Team _ Eason

[mahoneypat]

You should be able to use a measure like this in your table visual with your column of values to be searched (or as a visual level filter = 1).

Visible =
VAR slicervalues =
    VALUES ( Table1[SlicerColumn] )
VAR thisvalue =
    MIN ( Table2[SearchColumnValues] )
VAR rowsfound =
    FILTER ( slicervalues, SEARCH ( Table1[SlicerColumn], thisvalue, 1, 0 ) > 0 )
RETURN
    IF ( rowsfound > 0, 1, BLANK () )

Pat