Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Font issue with matrix in rdl file

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

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:

 

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

What could be happening ?

 

 

 

 

General Comment
Interesting Links
Need Help
Show and Tell

1 Reply

  • freginier's avatar
    freginier
    Icon for Solution Sage rankSolution Sage
    5 months ago

    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.