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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
v-eqin-msft
Community Support
Community Support

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
v-eqin-msft
Community Support
Community Support

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 @v-eqin-msft ! 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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors