Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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!!
Need Help
  • AlB's avatar
    AlB
    7 years ago

    Hi Anonymous

     

    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"
)
AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
7 years ago

Hi Anonymous

 

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"
)
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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