Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 !!!!!!!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |