Forum Discussion
Power BI Paginated Report with One column only
- Anonymous2 years ago
Hi, Anonymous
According to your description, I use the following data set to create the form in your description:
Add our data set in the Report builder:
We can add a custom table:
In the table definition, enter the name of the first column:
In the second column, enter the Field value in the first row and the fields in the dataset in the other rows:
We run our paginated report and see the following results:
Another problem you mentioned is that you have too many fields and it exceeds one page. Then you can consider the following two methods:
Reduce the fields used in the custom table
Add a parameter filter. This is the most common method. The following demonstrates the use of this method:First, add a parameter dataset, which contains the fields we need to add as parameters:
Bind this parameter to our dataset1 to complete the filtering effect:
The results are as follows:
The above are the methods that can be implemented currently.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, Anonymous
According to your description, I use the following data set to create the form in your description:
Add our data set in the Report builder:
We can add a custom table:
In the table definition, enter the name of the first column:
In the second column, enter the Field value in the first row and the fields in the dataset in the other rows:
We run our paginated report and see the following results:
Another problem you mentioned is that you have too many fields and it exceeds one page. Then you can consider the following two methods:
Reduce the fields used in the custom table
Add a parameter filter. This is the most common method. The following demonstrates the use of this method:
First, add a parameter dataset, which contains the fields we need to add as parameters:
Bind this parameter to our dataset1 to complete the filtering effect:
The results are as follows:
The above are the methods that can be implemented currently.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Anonymous2 years agoNot applicable
Anonymous Thank you so much for the help! I initially started with a table and tried to add a row at the bottom but it did not insert the row proplery like yours did. With your screenschots and description I was able to add row below within group in the right order. Thank you!
I do have a parameter, several actually. Even with filter the output still goes beyond one page and it cuts off where the page ends and starts on the next page. How can I insert a page break?
Thank you so much again!