Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!!
Solved! Go to 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" )
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" )
Thanks @AlB i have tried with selectedvalue and forgot to use isfiltered ..haha thanks anyway !!!!!!!!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |