Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Contains Filter issue

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.
Thanks in Advance!
Need Help
Show and Tell
Tips and Tricks

2 Replies

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    5 years ago

    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

     

     

     

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    5 years ago

    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