Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
npine
Frequent Visitor

Power BI Paginated Report with One column only

Is it possible to create a paginated report in Power BI Report Builder with only one column only? The report will look like a form that needs to be printed. A sample of what it would like is below: 

npine_0-1723501739282.png

There are a lot of fields and go beyond one page. I am also having issues with adding page break. Do I need to use a List?

Thank you.

1 ACCEPTED SOLUTION
v-jianpeng-msft
Community Support
Community Support

Hi, @npine 

According to your description, I use the following data set to create the form in your description:

vjianpengmsft_0-1723512826236.png

Add our data set in the Report builder:

vjianpengmsft_1-1723512875579.png

We can add a custom table:

vjianpengmsft_2-1723512922773.png

In the table definition, enter the name of the first column:

vjianpengmsft_3-1723513054855.png

In the second column, enter the Field value in the first row and the fields in the dataset in the other rows:

vjianpengmsft_4-1723513148735.png

vjianpengmsft_5-1723513196134.png

We run our paginated report and see the following results:

vjianpengmsft_6-1723513358860.png

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:

vjianpengmsft_7-1723513562657.png

vjianpengmsft_8-1723513573666.png

vjianpengmsft_9-1723513594404.png

Bind this parameter to our dataset1 to complete the filtering effect:

vjianpengmsft_10-1723513643445.png

vjianpengmsft_11-1723513672499.png

The results are as follows:

vjianpengmsft_12-1723513705976.png

vjianpengmsft_13-1723513721028.png

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.

 

 

 

 

 

 

 

 

 

 

 

 

View solution in original post

3 REPLIES 3
npine
Frequent Visitor

I think the table with rows might be a challenge since the output I'm looking for needs to print with no repeating values e.g. names, salespersonid etc.. When previewed it should only show something like below: 

npine_0-1723559341716.png

For what I am working on there are more field names that need to be added that's why it goes over one page. It's really like a printout of a form that I'm trying to achieve. Apologies if I was not clear enough with my problem description. 
Thank you again for your response and help!

 

v-jianpeng-msft
Community Support
Community Support

Hi, @npine 

According to your description, I use the following data set to create the form in your description:

vjianpengmsft_0-1723512826236.png

Add our data set in the Report builder:

vjianpengmsft_1-1723512875579.png

We can add a custom table:

vjianpengmsft_2-1723512922773.png

In the table definition, enter the name of the first column:

vjianpengmsft_3-1723513054855.png

In the second column, enter the Field value in the first row and the fields in the dataset in the other rows:

vjianpengmsft_4-1723513148735.png

vjianpengmsft_5-1723513196134.png

We run our paginated report and see the following results:

vjianpengmsft_6-1723513358860.png

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:

vjianpengmsft_7-1723513562657.png

vjianpengmsft_8-1723513573666.png

vjianpengmsft_9-1723513594404.png

Bind this parameter to our dataset1 to complete the filtering effect:

vjianpengmsft_10-1723513643445.png

vjianpengmsft_11-1723513672499.png

The results are as follows:

vjianpengmsft_12-1723513705976.png

vjianpengmsft_13-1723513721028.png

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.

 

 

 

 

 

 

 

 

 

 

 

 

@v-jianpeng-msft 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!

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

August Carousel

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors