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
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
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.

Sept NL Carousel

Fabric Community Update - September 2024

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