Formatting a row in bold/background

Hi Aqua1 

In Power BI, you cannot directly format column headers based on row values. Conditional formatting works on cell values, not headers.

Here’s a common approach:

1. Create a DAX measure to flag the rows you want to emphasize, for example:

HighlightRevenue = 
IF(
    'P&L'[RowName] IN {"Gross Revenue", "Revenue", "Gross Profit"},
    1,
    0
)

1. Apply conditional formatting (font color or background color) on the values in the table/matrix based on this measure.

2. For headers, a common workaround is to make the default table font lighter, then use the conditional formatting to make “Revenue” or “Gross Profit” rows darker/bold—this visually emphasizes those lines.

This achieves the effect you want even though headers themselves cannot be dynamically bolded.

If this helps, consider marking it as the solution and giving a kudo!

Nabha Ahmed

Hi Aqua1,

Conditional formatting on row and column headers is currently not supported. Changing to font to bold also cannot be controlled with conditional formatting. The only way for the font to become bold is it becomes a subtotal row  - not another row separate from its own line items. You can achieve that by using a hierarchichal table.  In the image below, the upper hiearachy is P&L Group and below it is Line Items:

You can write a condition to return blank if P&L Group is Gross Profit and Line Items is expanded otherwise you return the desired value.

VAR _group =
    SELECTEDVALUE ( DisplayTable[P&L Group] )
RETURN
    IF (
        _group = "Gross Profit"
            && ISINSCOPE ( DisplayTable[Line Items] ),
        BLANK (),
        [pnl value]
    )

The image below shows that Gross Profit is a subtotal row, the font is bold and although expanded doesn't have line items below it.  If the user doesn't need to expand/ collapse the rows, you can just icon the icons as well.