Dynamic URL based on a measure's value as a data source

Hi PaulTrower01 ,

Currently I'm afraid that's not possible.

You can create a parameter to replace part of the number in the URL.

Dynamic M Query Parameters allows you to bind a field to a parameter so that a single field value can be passed dynamically to the parameter.

Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn
However, this only applies to tables in Direct Query connection mode and does not apply to measures.
Instead, tables created through the Web Connector are in Import connection mode.

Therefore, you can only change the data source manually by changing the parameter values.

Best Regards,
Dengliang Li

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