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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
martim224
Frequent Visitor

Report Builder - How to show column headers and row headers always.

i have a matrix set up in report builder and i want to make the row and column categories static so it keeps it shape for the various parameters.  I have changed my expression for my data to show a zero for blanks but the rows and columns will still change and disapper if there is no data.

 

 

martim224_2-1646955211750.png

 

martim224_1-1646955178104.png

 

1 REPLY 1
v-yanjiang-msft
Community Support
Community Support

Hi @martim224 ,

Here's an article about this topic: Control row & column headings in a paginated report - Microsoft Report Builder 

Hope it helps!

 

Best Regards,
Community Support Team _ kalyj

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

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors