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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. 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
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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.