cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PunchBird
Resolver II
Resolver II

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!

1 ACCEPTED SOLUTION
PunchBird
Resolver II
Resolver II

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)

View solution in original post

8 REPLIES 8
PunchBird
Resolver II
Resolver II

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)
PunchBird
Resolver II
Resolver II

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

hi @PunchBird ,

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!

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

Hi @PunchBird ,

 

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!

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

Hi @PunchBird ,

 

Please refer this link,

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

 

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
Super User
Super User

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

 

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

and use that

Helpful resources

Announcements
Vote for T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Vote for your favorite t-shirt design now through March 28.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

March Events 2023A

March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors