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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

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.