Forum Discussion

patilpoonam21's avatar
2 years ago
Solved

Dynamically change the URL link for different Environment in Power BI

Hi,   Currently in my 'Global' PBI file, I have a table and when I click on the column in the table 'PBICustLink' , it redirects me to the another PBI 'Customer' which has customer level informatio...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi patilpoonam21 ,
    Based on your description and the example data provided, I think you can dynamically change the URL links for different environments (development, test, and production) in Power BI by setting parameters.
    Here some steps that I want to share, you can check them if they suitable for your requirement.
    Here is my test data:

    1.Open power query and create a parameter and enter the values you want for your test environment or other dynamically changing values

    2.Right click the parameter and choose enable load to apply parameter

     

    3.Create a measure

     

    PBICustLink = 
        CONCATENATE(
            SELECTEDVALUE('Environment URL'[Environment URL]), 
            "/reports/&filter=OpenInv%2F" & SELECTEDVALUE('Table'[Customer]) & " eq " & "%" & 27 
        )

     

    4.Final output

    Replace any value in the measure as you see fit.

    You can refer to these documents to learn more about parameter settings:
    Deep Dive into Query Parameters and Power BI Templates | Microsoft Power BI Blog | Microsoft Power BI
    Use parameters to visualize variables - Power BI | Microsoft Learn

     

    Best regards,

    Albert He

     

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