Reply
Member
Posts: 96
Registered: ‎08-29-2018
Accepted Solution

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


Accepted Solutions
Super User
Super User
Posts: 1,274
Registered: ‎11-12-2018

Re: Return records from slicer

[ Edited ]

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"
)

View solution in original post


All Replies
Super User
Super User
Posts: 1,274
Registered: ‎11-12-2018

Re: Return records from slicer

[ Edited ]

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"
)
Highlighted
Member
Posts: 96
Registered: ‎08-29-2018

Re: Return records from slicer

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