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

[Anonymous]

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!

[Anonymous · Accepted solution]

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]

 @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]

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]

@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]

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]

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

[NikhilChenna]

Hi @Anonymous ,

Please refer this link,

https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-hyperlinks-in-tables?tabs=powerbi-desktop

https://www.youtube.com/watch?v=m4a2c55eXMU

This will help you out.

Regards,

Nikhil Chenna

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

[amitchandak]

@Anonymous , You need create dynamic url in that case like

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

and use that