Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
PunchBird
Helper V
Helper V

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
Helper V
Helper V

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
Helper V
Helper V

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
Helper V
Helper V

 @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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors