Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello
How to overcome supplying a table of multiple values in Field parameters while SELECTEDVALUE doesn't work as it creates an error according to sqlbi https://www.sqlbi.com/blog/marco/2022/06/11/using-selectedvalue-with-fields-parameters-in-power-bi/
I just want to have value of 1 when I got certain field from field parameters slicers (Country), and 0 for the rest. Before I established hierarchy-like slicers from this video https://www.youtube.com/watch?v=5G_xSJy5muo it was working properly
@Pbiuserr , To get the selected value from field parameters you can try like
seleceted measure = maxx(FILTER('Measure Slicer', 'Measure Slicer'[Measure Slicer Order] = SELECTEDVALUE('Measure Slicer'[Measure Slicer Order])), 'Measure Slicer'[Measure Slicer])
more than one
seleceted measure = concatenatex(FILTER('Measure Slicer', 'Measure Slicer'[Measure Slicer Order] in values('Measure Slicer'[Measure Slicer Order])), 'Measure Slicer'[Measure Slicer], " ,1")
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 58 | |
| 43 | |
| 41 | |
| 23 | |
| 17 |
| User | Count |
|---|---|
| 188 | |
| 118 | |
| 96 | |
| 64 | |
| 45 |