Forum Discussion
BI Report Linking like hyperlink.
- 8 years ago
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
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
Cherry,
Thank you so much for sharing time and efforts to address this matter.
Here are steps and PDF link to understand graphical representation to understand bit better.
https://drive.google.com/open?id=1f8C1G7i2vt1L8MVo1yIJud-J9Bl5W71q
We have 3 reports and steps to follow:
Report # 2:
- We have Report # 2 (Report 2 - Tag 1) which has few columns (Report 2 - Tag 2-8)
- We want to split this one into multiple report and each report show have different kind of charts.
- For this example, report we will split Report # 2 into further two names as Report # 3 & 4.
Report # 3:
- We have taken the first column from Report # 2 (Report 2 - Tag 2) and created new Report # 3.
- We want to show Bar chart for this report (Report 3 - Tag 1).
- When we click on each bar chart column or associated row (Report 3 - Tag 2 or Tag 3) we want to link to another Report # 4 which filter records only for selected row or chart bar. e.g. ‘Federal Compliance’ or General Tracer’
Report # 4:
- This is almost the same one as Report # 2, except it does not have ‘Tracker Type’ column (Report 2 - Tag 2).
So, Report # 2 is our current situation and we split the data and want to link Report # 3 with filtered data in Report # 4 upon Report 3 selected record click.
Also, bookmark feature that you have mentioned will not work for us, as we want differnt kind of charts for selected dataset.
For this drill we just want to Report #3 to link to Report # 4 with filtered data - severt report option is not valid for now. but if we know how to link one report to other can achieve with several as well, I believe.
Thanks much,
-Ahsan
- v-piga-msft8 years agoResident Rockstar
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
- ahsan8 years agoRegular Visitor
Thank much for confirming - much appreciated.
-Ahsan