Paginated Reports optional parameter help

[hannahsamd]

Hi, 

I have a report that I am builder in Power BI report builder. I have 2 parameters, Year and Quarter. I am creating quarterly and yearly reports. I want the quarter parameter to be optional so I can easily get the yearly report in the same place as the quarterly report. ANy help would be great! Right now the parameters are just drop downs

[KVRKarthik]

Hi hannahsamd,

Follow the steps given below to achieve this.

1. Add a dataset to the report with column of Year evaluated from the Year column of the data.

2. Add another dataset with column of Quarter from the Quarter column of the data.

3. Add first parameter as "Year" with "Available Values" assigned to column from Step 1.

4. Add second paramter as "Quarter" with "Available Values" and "Default Values" assigned to column from Step 2.

5. Add these parameters as query parameters/ filters on dataset which is assigned to Tablix.

When you're willing to get Year wise, you can select only year. When you're willing to get Year-Quarter wise data, you can select both in a same report.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[hannahsamd]

Hi! When I get to step 4, I am getting the error "Multiple values were specified for the parameter, but the parameter does not allow multiple values

[KVRKarthik]

To resolve this,

In parameter properties, go to "General" window, check the option "Allow Multiple Values".