cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gokul Member
Member

Return records from slicer

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!!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Return records from slicer

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"
)
2 REPLIES 2
Highlighted
Super User
Super User

Re: Return records from slicer

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 Member
Member

Re: Return records from slicer

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