Forum Discussion
Impactful IndividualFilters on Paginated Report
can i add filters or slicers on paginated report created using report builder tool?
Hello powerbiexpert22
Yes, you can do that, but you need to pass the parameter within the query and then use it as a parameter before generating the report.
To illustrate how to do this:
For example, if you want to select a period in a report built on an Oracle Database,
First, create your parameter variable.
Then create your Dataset with a query (in this example, I used a very simple query)
SELECT *
FROM DWH_View
WHERE BILL_PERIOD = :BillPeriod
Then click on Parmaeters in your query window and match the parameter name, so in our case :BillPeriod with the parameter value we created at the previous stepNow, each time, you will run your report, you will have to specifiy a parameter
Now if you want, instead of having a free text box, you can specifiy some avaialble values, (specific one or via query)
If you run your report (I have other parameters in my report), you have a blank report until your specify the required parameters
If you need more support, to not hesistate to ask for some help
6 Replies
- bhanu_gautam
Super User
powerbiexpert22 Yes, you can add filters or slicers to a paginated report created using the Report Builder tool. Filters can be applied at various levels, such as dataset, data region, or group levels, to control the data that is displayed in the report.
powerbiexpert22Hi bhanu_gautam , can i create multiple pages ( like we create using power bi desktop) report using report builder, also can i export that report in excel into multiple pages with format retained?
- Cookistador
By default, it will create many pages
But if I want, you can specify a page break at the end of a visual
You can also use subreport to set up a look a field like in Power BI
- Cookistador
Hello powerbiexpert22
Yes, you can do that, but you need to pass the parameter within the query and then use it as a parameter before generating the report.
To illustrate how to do this:
For example, if you want to select a period in a report built on an Oracle Database,
First, create your parameter variable.
Then create your Dataset with a query (in this example, I used a very simple query)
SELECT *
FROM DWH_View
WHERE BILL_PERIOD = :BillPeriod
Then click on Parmaeters in your query window and match the parameter name, so in our case :BillPeriod with the parameter value we created at the previous stepNow, each time, you will run your report, you will have to specifiy a parameter
Now if you want, instead of having a free text box, you can specifiy some avaialble values, (specific one or via query)
If you run your report (I have other parameters in my report), you have a blank report until your specify the required parameters
If you need more support, to not hesistate to ask for some help
- v-saisrao-msft
Community Support
Hi powerbiexpert22,
Have you had a chance to review the solution we shared by Cookistador bhanu_gautam? If the issue persists, feel free to reply so we can help further.
Thank you.
- v-saisrao-msft
Hi powerbiexpert22,
Checking in to see if your issue has been resolved. let us know if you still need any assistance.
Thank you.
