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

2 Replies

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