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
dmkblesser
Helper I
Helper I

Hyperlink in Paginated Report

Hi guys, I have a question on the hyperlinks in paginated report. 

 

dmkblesser_0-1684431200576.png

 

In SSRS, if we want to allow user to click on field to access the hyperlink based on some conditions, we can do IIF(parameter1 = "abc", nothing, URL). That way, when parameter1 = "abc", the hyperlink won't work for user for that field. 

 

In PowerBI paginated report, if we do the same, it will still allow user to click on the hyperlink, but will direct to a blank link: https://paginated-reports.powerbi.com/# and keep rendering. 

 

Is there a way to dynamically turn on and off of the hyperlink in Power BI paginated report? or make it at least behaviors the same as SSRS?

3 REPLIES 3
EevaMFin
New Member

Hi, I'm facing the same issue, has anyone found a workaround to this? 

 

In my case, this "go to URL" is used for drill-through.

GilbertQ
Super User
Super User

Hi @dmkblesser 

 

What happens if you leave the result as blank instead of a value, what happens then?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Hi GilbertQ, are you saying do something like this? iif(parameter1 = "ABC",, URL)? it will show an error message for  Argument not specified for parameter "TruePart" of "Public Function IIf()

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.