How to Create Parameter in Paginated Report in Power BI Report Builder?
Paginated Reports like Invoices, Memos, and Documents that we can print, and most importantly these reports are pixel-perfect. Parameters are used to filter or interact with data in the paginated report.
If you’re struggling to implement parameters in your paginated reports, you are in the right place. I will explain easy steps to implement them with a simple example.
Step 1:- Add Dataset by right-clicking on the dataset folder in the Report Data pane.
Next window you will get Dataset Properties -
1. Give the name to the dataset, I am giving it Superstore_Dataset.
2. Connect with Data Source, I am connecting with the Semantic Model and also giving a name to the data source such as Sales.
3. After connecting to the dataset click on Query Designer Button Dataset Property Window and get the dataset fields that you want to use in the Paginated report.
4. Report Builder Create a Query for you whatever the column you loaded in the Query Designer.
Hit OK…. and Congratulations !!
We have successfully loaded the dataset in the Power BI report Builder.
Now, suppose we want to create a parameter for the Region to print the Region Wise Sale
for that, First, we will create a Region dataset similar to the previous step only difference now we have to load only one column from our dataset which is Region and the query will look like
After hitting OK… we will get our Region DataSet in our Dataset Folder in Report Pane.
Step 2:- Now, it is time to create Parameters
Now, we will add a Parameter for the Region, for that we have to follow the below steps.
- Create a Parameter from the Report Pane by Right-clicking on the Parameter folder and giving the name to the parameter like Pregion and Prompt is nothing like the title of the parameter that will display in the report.
Next, click on the Available Value tab fill in the name of the dataset Region and value field, and label field with the region value.
Next, the Default Values tab will fill with Region detail.
Hit ok .. Hurry…!!! The parameter has been created.
If the Parameter is not visible to you on the screen then go to the View tab on Ribbon and tick on the Parameter option it will come automatically.
Now we will Add one Table in the report so that we can test whether the parameter is working properly or not.
Now, to implement the parameter on the table we will add it in the Table property.
After right-clicking on the table we will get the Tablix Property option and after selecting it we will get a window
In the Tablix Property Window in the Filter tab, by clicking on the Add button we will get an Expression from Superstore Dataset Field -Region and Value from By clicking on the function button expression window will open and select the Pregion parameter that we created previously.
Now, Hit OK …and we are ready to go…!!!
Click on the Run button to check the preview and Boom….!!!
Our Paginated Report is ready with Parameter.
Now the Paginated report is ready to publish in Power BI services.
I hope this article is useful for you! If you found it helpful, please give it a clap and leave a comment if you have any questions. I would be happy to hear your thoughts.
Happy Learning…!!!
Don’t forget to subscribe to
and join our Power BI community
