Forum Discussion

dmkblesser's avatar
dmkblesser
Advocate II
3 years ago

Hyperlink in Paginated Report

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

 

 

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?

Need Help

3 Replies

    • dmkblesser's avatar
      dmkblesser
      Advocate II
      3 years ago

      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()

  • EevaMFin's avatar
    EevaMFin
    Frequent Visitor
    3 years ago

    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.