Dynamic Linking of Parameter Values

Power Query
1

I know you can create parameters by Drilling down on a cell in an Excel Table. However, is there ar way of linking a value to a Parameter in the Manage Parameter Dialog?

This would mean that when the cell in the worksheet changed the value of the parameter in the Manager Parameter Dialog would change automatically.

How would I do this?

Link.xlsx (15.0 KB)

Allister

2

Hi @AllisterB,

Please review this article

I hope this is helpful.

1 Like
3

Hi @AllisterB, did the response provided by @Melissa help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!

4

Thank you Melissa - it looks like just what I need

Allister