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")
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 68 | |
| 46 | |
| 44 | |
| 29 | |
| 20 |
| User | Count |
|---|---|
| 202 | |
| 130 | |
| 102 | |
| 71 | |
| 55 |