Forum Discussion

AndyDD_UK's avatar
AndyDD_UK
Helper III
1 year ago

Dynamic URL based on slicer selection

In my Dim Table I have a list of items, each with a URL link to the corresponding Power BI report.   In Power BI report 1 I have a matrix and users click on the URL icon to open up the appropriate ...
Need Help
johnt75's avatar
johnt75
Super User
1 year ago

You can create a measure like

Dynamic URL =
SELECTEDVALUE ( 'Dim Item'[URL] ) & "?year="
    & SELECTEDVALUE ( 'Dim Calendar'[Year] ) & "&month="
    & SELECTEDVALUE ( 'Dim Calendar'[CalendarMonth] )

You may need to change the URL parameter names to fit.

Make sure to set the Data category of the measure to Web URL.

  • AndyDD_UK's avatar
    AndyDD_UK
    Helper III
    1 year ago

    Thanks, to add I currently have a matrix listing the items and URLs as rows...users click on the URL to open up the report....my request is pass the slicer selection(s) to the new report.

     

    My understanding is I cannot use a measure as a row. How would I use that measure ? 

    • johnt75's avatar
      johnt75
      Super User
      1 year ago

      Keep the item name on the row and add the measure as a column. You can turn on the URL Icon setting so that it only shows a link icon rather than the full URL.

      • AndyDD_UK's avatar
        AndyDD_UK
        Helper III
        1 year ago

        Can't get that to work but will try again...

         

        Also, is the base URL the 'link' you generate when you share?....or should it be the URL in the browser ?...the browser link doesn't appear to change based on slicer selection...