Forum Discussion

ppgandhi11's avatar
ppgandhi11
Helper V
8 years ago
Solved

Report Parameter Question.

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-