Report Parameter Question.

[ppgandhi11]

I am creating a report with 2 pages (sheet).

1st is supposed to be upper level view of the report. It has 2 parameters (start date, end date). It works fine. It shows the results as expected. Based on the results shown here, I want to create 2nd page report.  Is it possible to build report page2 as a sub report of page1 selection?  If yes, how to go about it?

If not then it is okay. I can build page2 independent of page1 by forcing user to select specific datapoint in terms of parameter. However, when I do this, both the report page1 and page2 always shows 3 parameters (2 from page1, and 1 from page2). Is there a way to ask user for only relevant parameters for each page? I think it should be doable but since I am new to Power BI, I do not know.

Help is appreciated. Thanks. Prashant-

[TomMartens · Accepted solution]

Hey,

I guess what you are looking for ist the feature called "Drillthrough", more details can be found here:

https://docs.microsoft.com/en-us/power-bi/desktop-drillthrough

Hope this is what you are looking for

Regards

Tom