Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Button with URL link that only can be opened as from specific date

Hi,

I would like to create buttons with URL links that only can be opened as from a specific date. So for example the link in button 1 only works as from 1 December, button 2 as from 2 December etc. If these buttons are clicked on 30 November, nothing happens (or better: a pop-up appears that you can't click it yet). Is this possible in Power BI? 

Thanks!

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi all, I managed to solve it myself. In case anyone needs this in the future, here are the steps:

    • First, add a table with the URLs and what dates you want to allow them to be opened. In 'Column tools', change the data category of the column with URLs to 'Web URL'
    • Then create a DAX measure:
    Open URL =
    VAR _PickDate = CALCULATE(MAX('Table'[Date]),'Table'[Index]=1)
    VAR _Date = FORMAT(_PickDate,"yymmdd")
    VAR _Today = FORMAT(TODAY(),"yymmdd")
    VAR _Link = CALCULATE(MAX('Table'[URL]),'Table'[Index]=1)
    RETURN
    IF(_Today >= _Date, _Link)
    • Next, in the report, insert a button, turn on Action, change Type to 'Web URL' and under 'Web URL' click on the function-button (fx) and select the measure you just created
    • In the Tooltips I added a message for the user explaining why the URL can't be opened (if relevant)

8 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    Anonymous , You need create dynamic url in that case like

     

    measure = "URL>date="& format(selectedvalue(Date[date]), "yyyy-mm-dd")

    and use that

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

     amitchandak Many thanks! The URL's that are used in the report are fixed though, so what would the measure look like if viewers should only be able to open URL https://community.powerbi.com/ after 1/12/2022 ? Is this possible?

    • NikhilChenna's avatar
      NikhilChenna
      Icon for Skilled Sharer rankSkilled Sharer
      3 years ago

      hi Anonymous ,

      It is possible by using creating a dynamic measure, 

       

      Dynamicmeasure = "URL>date="& format(selectedvalue(Date[date]), "yyyy-mm-dd")

       

      Regards,

      Nikhil Chenna

       

      Appreciate with a Kudos!! (Click the Thumbs Up Button)
      Did I answer your question? Mark my post as a solution!

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        amitchandak NikhilChenna I am trying to implement your measure but it doesn't work. I probably don't create it correctly. Could you please give an example using 1/12/2022 as date and  https://community.powerbi.com/  as URL ? My apologies for not understanding!

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi all, I managed to solve it myself. In case anyone needs this in the future, here are the steps:

    • First, add a table with the URLs and what dates you want to allow them to be opened. In 'Column tools', change the data category of the column with URLs to 'Web URL'
    • Then create a DAX measure:
    Open URL =
    VAR _PickDate = CALCULATE(MAX('Table'[Date]),'Table'[Index]=1)
    VAR _Date = FORMAT(_PickDate,"yymmdd")
    VAR _Today = FORMAT(TODAY(),"yymmdd")
    VAR _Link = CALCULATE(MAX('Table'[URL]),'Table'[Index]=1)
    RETURN
    IF(_Today >= _Date, _Link)
    • Next, in the report, insert a button, turn on Action, change Type to 'Web URL' and under 'Web URL' click on the function-button (fx) and select the measure you just created
    • In the Tooltips I added a message for the user explaining why the URL can't be opened (if relevant)