Dynamic Web URL in Button Action?

[cbschley]

Hello - I am trying to build a dynamic web URL measure to use in a button action. This would then allow the user to click on the button, and it would take them to a certain paginated report depending on the environment they are in. 

When I build this measure, Power BI does not let me use it in the conditional formatting option in Power BI Desktop. I already have the environment piece configured, but I can't understand why it won't let me select this measure from the conditional formatting area. When I select my new measure to place in this area, it goes to blank, meaning it won't let me use it.

Dynamic_Button_Link = 

SWITCH(TRUE()
,Environment_Selection[Environment_Selection] = "Dev", "https://app.powerbi.com/groups/bb8da941-c096-4913-b68c-a0a72b192376/rdlreports/244915da-a877-4ba7-b7ca-0e650d3c99fd?experience=power-bi&clientSideAuth=0"
,Environment_Selection[Environment_Selection] = "Test", "https://app.powerbi.com/groups/10d6094c-b41e-415e-8873-e8287a133e23/rdlreports/58e4a8d8-d2c4-44c5-bbe0-e04413420edb?experience=power-bi&clientSideAuth=0"
,Environment_Selection[Environment_Selection] = "Prod", "https://app.powerbi.com/groups/e9ddc1dd-945b-4414-a82b-42b25730eb50/rdlreports/e88de90d-59a7-4e4f-9862-00b1fdf6ceab?experience=power-bi&clientSideAuth=0"
)​

[SamWiseOwl]

When I copied your code both times it copied something at the end of the code.

I had to hit the delete key after the final bracket to remove it.

Not sure if that is related!

once I hit the delete key after the final bracket

[cbschley]

That might be a weird formatting thing with the forums. Another comment suggested changing the data category to URL, and that worked! 

[SamWiseOwl · Accepted solution]

Have you set the measure to be a URL?

[cbschley]

This worked - thank you! I did not know I had to set the data category in order for this to work.