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
arifshah
Helper I
Helper I

Format the headers/columns of a matrix in paginated reports in report builder

Hi,

 

I am trying to design a matrix in paginated reports (using power bi report builder). The design requires that the rows have borders and the columns are split by leaving some blank spaces between them. Since there are no blank space border, I have used white column border (right border using white color) to induce a blank space in the columns. See the attached image.

 

arifshah_0-1705676346244.png

 

I have done it for the  groups in the headers (columns) as well as the cells in the value area. It seems to have worked in the value area but there are no blank space in the header area. Look at the image below

 

arifshah_2-1705676724695.png

 

As you can see, there is a clear white space between two columns in the value area (its actual white border) but in the header area, there is no division. I even increase the white border size in the header to 10pt but i dont see a clear white space in the headers as we can see in the value area.

 

This is the property that I have used

 

arifshah_3-1705677776367.png\

 

I would appreciate if someone can help give a a clue.

 

 

 

 

1 REPLY 1
v-xinruzhu-msft
Community Support
Community Support

Hi @arifshah 

You can review the matrix properties, and make sure the properties you set is right, and you can refer to the following link.

https://learn.microsoft.com/en-us/sql/reporting-services/report-design/controlling-row-and-column-he...

 

Best Regards!

Yolo Zhu

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

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

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

Top Solution Authors