Dynamic text column selection based on slicer selection in Power BI

Hi, Anonymous 

According to your description, I think you can try to create a new table for the slicer and create a measure to achieve this, you can try this:

1. Click “Enter data” to create a new table:

2. Create a measure:

Dynamic column =

var _selectedfunction=SELECTEDVALUE(Slicer[Function])

return

SWITCH(

    _selectedfunction,

    "HR",MAX('Table'[HR Score]),

    "Other",MAX('Table'[Other Score]),

BLANK())

3. Create a table chart and a slicer and place them like this:

And you can get what you want.

You can download my test pbix file below

Thank you very much!

If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.