Return records from slicer

[Gokul]

Is it possible to the return the records from slicer??

My scenario will be like, if am selecting any filters from slicers, then I have to add some message (ie) Filter is applied!!

[AlB · Accepted solution]

Hi @Gokul

Place the following measure in a Card visual. It will show a list of the items selected in the slicer (if any). You can change the text message and delimiter as you see fit.  Table1[Column In Slicer] is the field in your slicer

ShowSlicerContents =
IF (
    ISFILTERED ( Table1[Column In Slicer] );
    "Filter aplied. Values:" & UNICHAR ( 10 )
        & CONCATENATEX ( DISTINCT ( Table1[Column In Slicer] ); Table1[Column In Slicer]; ", " );
    "No filter applied"
)

[Gokul]

Thanks @AlB i have tried with selectedvalue and forgot to use isfiltered ..haha thanks anyway !!!!!!!!