Forum Discussion
Power BI Report Builder - How to add multiple drillthrough reports options to a single cell
- 6 years ago
This is what I did. I created a new prompt with two labels/values - Report1/1 and Report2/2. Then I went back to the Cell Properties->Action where the URL is given. Here added something like this -
=IIF(Parameters.Name.Value = 1, Report1 URL, Report2 URL)
The Report URLs have all those other parameter that need to be passed to drillthrough reports. When the report is run and Report1 option is selected for the new parameter, the cells will open Report1 when you click on it.
There is a small compromise though. Every time I change the report option, I have to click on "View Report" button again for the the drillthrough action to open the correct report.
I will update if I find a better solution.
Thanks!
Update with another method - As the requirement is to get to multiple drillthrough reports from the Main report, these reports will have common dimensions. In the Power BI Drillthrough Dataset, I created common dimension tables for both the Datasets and linked each dimension table to the two Datasets. The parameter values from the Main report will be sent to the common dimensions which in turn will filter both the reports in separate tabs at the same time.
This is what I did. I created a new prompt with two labels/values - Report1/1 and Report2/2. Then I went back to the Cell Properties->Action where the URL is given. Here added something like this -
=IIF(Parameters.Name.Value = 1, Report1 URL, Report2 URL)
The Report URLs have all those other parameter that need to be passed to drillthrough reports. When the report is run and Report1 option is selected for the new parameter, the cells will open Report1 when you click on it.
There is a small compromise though. Every time I change the report option, I have to click on "View Report" button again for the the drillthrough action to open the correct report.
I will update if I find a better solution.
Thanks!
Update with another method - As the requirement is to get to multiple drillthrough reports from the Main report, these reports will have common dimensions. In the Power BI Drillthrough Dataset, I created common dimension tables for both the Datasets and linked each dimension table to the two Datasets. The parameter values from the Main report will be sent to the common dimensions which in turn will filter both the reports in separate tabs at the same time.