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....
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)
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!

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

      Hi Anonymous ,

       

      DynamicMeasure = 
      "https://community.powerbi.com/ "&format("1/12/2022"), "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

        NikhilChenna thanks for this but it doesn't work... the syntax isn't even correct