Forum Discussion
SELECTEDVALUE on Field Parameter VALUE, not COLUMN
- 9 months ago
Hi — in Power BI field parameters don’t expose a “give me the current row value of the selected column” function.
SELECTEDVALUE() on the parameter table can tell you which field (name) is selected, but DAX cannot dereference a column reference dynamically and return its value (there’s no “dynamic column pointer” you can evaluate). So if you want Val1/Val2/Val3 from whichever column is selected, you’re basically limited to one of these patterns:
Option 1 (most common): SWITCH mapping
Yes, it’s the standard answer: map the selected parameter item to the underlying column/measure using SWITCH().Option 2 (cleaner at scale): use Measures in the field parameter + a Calculation Group
Instead of putting columns in the field parameter, create measures (one per field) and build the parameter on those measures. Then use a calculation group with SELECTEDMEASURE() to apply common logic without repeating it 20 times. This reduces hard-coding and is much more maintainable.Bottom line:
➡️ No, you can’t directly retrieve the selected column’s value from a field parameter without mapping (because DAX doesn’t support dynamic column evaluation).
➡️ For 20+ fields, the best practice is field parameters over measures + calculation groups, or fall back to a SWITCH().If you share whether those 20 fields are numeric measures or text columns, I can suggest the cleanest structure (and a template that avoids repeating logic).
- 9 months ago
Hi sahabatsuria
Field parameters are not actual columns; they only function as selectors for columns or measures. It isn’t possible to dynamically display the values of the selected column directly from a field parameter slicer. Those values can only be shown in visuals such as tables, matrices, or other visuals that have row context. To display different values based on the field parameter selection (in a card or similar visuals), the appropriate approach - which you have already mentioned - is to use a SWITCH expression that responds to the slicer selection.
Hi sahabatsuria ,
Thank you mohit_sakhare for the response provided!
Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.
Thank you.
Hi sahabatsuria ,
I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.
Thank you.