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

Get Fabric Certified for FREE during AI Skills Fest. This week only. Secure your voucher now.

Reply
Anonymous
Not applicable

Font issue with matrix in rdl file

In Power BI Paginated Report we have selected the font type for the rows in the Matrix. 

db2907_0-1700847000966.png

When we export the Excel file from Power BI the matrix is collapsed like this, and the font is the right one for the first level:

db2907_1-1700847077931.png

 

But, when we expand the other levels, we are getting this :

db2907_2-1700847113720.png

What could be happening ?

 

 

 

 

1 REPLY 1
freginier
Super User
Super User

The fact that the expanded levels fall back to Courier New is the giveaway - Courier New is the default substitute the Excel rendering extension uses when it can't apply the font you specified on those rows. So the font is being lost on the dynamically-expanded child rows, not genuinely set to Courier New.

 

A few things that usually fix it:

- Set the Font on the textbox (cell) itself for every level, ideally as an expression based on the row-group level, so each level gets its font explicitly rather than inheriting from a parent group that collapses on expand. Setting it per textbox stops the fallback.

- Make sure the font (Algerian, and whatever you want on the lower levels) is a TrueType font installed on the rendering host - the Power BI service / report server machine, not just your authoring PC. If the font isn't present server-side, the export substitutes Courier New, which is exactly the symptom here.

- Sanity check: render to PDF. If PDF shows the correct fonts but Excel doesn't, it confirms it's the Excel rendering extension's handling of toggled rows, and the explicit per-textbox/per-level font is the workaround.

 

So: apply the font explicitly at the textbox level for each row-group level, and confirm the font is installed on the server doing the rendering.

Helpful resources

Announcements
May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.