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-
