cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mdubose
Helper I
Helper I

Filter report table values as hyperlink

Hello,

I have Power BI Desktop optimized for Report Server.  I have two reports within the same report. 

 

Report1 table value should link to Report2.  For example:

 

Report1:

Table1

a1
b2
c3

 

Report2:

Table1

Data from row a

 

I've followed the steps in this article: Filter a report using query string parameters in the URL by creating a string parameter URL then using conditional formatting and web url to make my column a hyperlink that links to Report2.

 

This works fine if Report2 was a seperate report that's published to Report Server. However, how can I navigate from Report1 to Report2  within the same report where the table values are a hyperlink?

 

I want to add a functionality in which if I click on a particular table value it leads me to another page or bookmark in same report. 

1 ACCEPTED SOLUTION
rajulshah
Memorable Member
Memorable Member

@mdubose ,

 

The functionality you stated can be easily achieved using Drillthrough. May I ask why you aren't using drillthrough feature?

View solution in original post

3 REPLIES 3
rajulshah
Memorable Member
Memorable Member

@mdubose ,

 

The functionality you stated can be easily achieved using Drillthrough. May I ask why you aren't using drillthrough feature?

@rajulshah ,

I'm able to achieve my requirement using Drillthrough.  Thank you.

Hi @rajulshah ,

I'm not familiar with the drillthrough feature. Is this feature available in Power BI Desktop optimized for Report Server?

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors