Forum Discussion
BI Report Linking like hyperlink.
Hi there,
I am using Online BI Module to develop reports.
Wondering how we can connect report like a hyper link with eachother.
For an example:
Parent Table 1 --- Child Table 1.1
--- Child Table 1.2 --- Child Table 1.2.1
--- Child Table 1.2.2
--- Child Table 1.2.3
--- Child Table 1.3
multiple table links to each other one to many relationship. If i click on parent primary key column I should be able to nevigate to child table detail which is in anotehr report and so one.
Thanks,
-Ahsan
Hi ahsan,
For your sceanrio, it seems that Drill through should be the choice.
If you think drill through cannot help you, I'm afraid that there is no better way to achieve your requirement.
Best Regards,
Cherry
6 Replies
- v-piga-msftResident Rockstar
Hi ahsan,
It seems that you're are looking for Drill through feature.
You could have a reference of this document about how to use Drill through in Power BI.
In addition, you also could refer to Bookmark in Power BI.
You could have a good look at this video which demo around 52:00 shows drilling into other reports from visuals, and a whole bookmarking feature.
Best Regards,
Cherry
- ahsanRegular Visitor
Thanks Cherry for your response.
Yes, I am looking for drill down funtionality but not from one object to another - on click want to link report and I believe parameter passing will happen somewhere as well.
Parent Table 1 (Bar Chart ) --- Child Table 1.1 (Pi Chart)
--- Child Table 1.2 (Pi Chart) --- Child Table 1.2.1 (Line Chart)
--- Child Table 1.2.2 (Line Chart)
--- Child Table 1.2.3 (Line Chart)
--- Child Table 1.3 (Pi Chart)
Thanks,
- v-piga-msftResident Rockstar
Hi ahsan,
What about Bookmark feature in Power BI I mentioned for the first reply?
In addition, do you want to link the tables in one report or several reports?
If it is convenient, could you share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)
Best Regards,
Cherry