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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
elin2
Frequent Visitor

Repeating list values, matrix in list issue - Power BI Report Builder

I'm working in Power BI Report Builder and I have some questions. 

 

I'm using a list and a matrix and I'm using a page break to distribute the data across multiple pages. In the list, I'm displaying some overall values from the group, and in the Matrix, I'm showing detailed data broken down by sample number. I have an issue in this that I'm hoping someone can help me with!

 

Screenshot 2022-06-07 at 15.58.53.png

^Current setup 

 

The last column is dynamic and I don't know how many columns it will end up displaying. For some of my samples, there are so many that the matrix overflows to the next page. I'm repeating the other columns when this happens and I'm happy with the matrix but the text values on the top of my list are not repeating when the matrix is overflowing to the next page. So on the first page of a matrix we have the headers but when it overflows to the next page it's empty. I set the RepeatWith properties of the four text boxes to repeat with the matrix but it's not working. Also tried to set them to repeat with the list but it makes no difference. Has anyone done this before and can help me out? 

 

elin2_1-1654611608029.png

^What I want every page to look like 

elin2_0-1654672726737.png

^What it's currently looking like on the page where the matrix overflowed  

 

 

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @elin2 ,

 

Workarounds have been mentioned in the threads:

How to repeat a textbox on each page (ssrs 2005 or 2008 )

repeat textbox (not in header) on every page

 

Eyelyn9_0-1655088365110.png

Eyelyn9_0-1655088554481.png

 

Best Regards,
Eyelyn Qin
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

2 REPLIES 2
Anonymous
Not applicable

Hi @elin2 ,

 

Workarounds have been mentioned in the threads:

How to repeat a textbox on each page (ssrs 2005 or 2008 )

repeat textbox (not in header) on every page

 

Eyelyn9_0-1655088365110.png

Eyelyn9_0-1655088554481.png

 

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

Thank you @Anonymous ! I put all my info that needs repeating in the text box. I had to put everything in the first column for it to fit so now I have 4 values of text in a row instead of 2 and 2 but that will have to work. 😁

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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