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.
Hi,
What is best way to capture slicer selections in power bi.
Have seen
IF(ISFILTERED('Suppliers Details'[CompanyName]), SELECTEDVALUE('Suppliers Details'[CompanyName], "Multiple Selections"), "No Selection") but how can we best capture each and every selection in the slicer?
e.g Selected YearWks = 2018, 2019 Selected Product = Cereal...
Thanks
Solved! Go to Solution.
Hi @po,
What's the expected result? There aren't many tricks. If you'd like to see the details, you can try the measure below.
Measure = IF ( ISFILTERED ( Table1[YearWks] ), CONCATENATEX ( VALUES ( Table1[YearWks] ), [YearWks], "-", 0 ) )
Best Regards,
Dale
Hi @po,
What's the expected result? There aren't many tricks. If you'd like to see the details, you can try the measure below.
Measure = IF ( ISFILTERED ( Table1[YearWks] ), CONCATENATEX ( VALUES ( Table1[YearWks] ), [YearWks], "-", 0 ) )
Best Regards,
Dale
What if you have multiple slicers, same table for example, Year, Month, Quarter, Day, is it possible to concat all? What's the syntax?
Measure = IF ( ISFILTERED ( Table1[YearWks] ), CONCATENATEX ( VALUES ( Table1[YearWks] ), [YearWks], "-", 0 ) )
Hi,
Thanks for reply- you suggested solution works great.
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 |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |