Forum Discussion

Emma_'s avatar
Emma_
Helper II
8 months ago
Solved

Row formatting in a table

Hello everyone,

I'm looking for options to format specific rows within native tables in Power BI. Specifically, I want to know if there's a way to make the text and values of only one row bold and italic, without using any custom visuals.

If anyone has experience with this or can point me in the right direction, I'd appreciate your insights!

Thank you

 

Below my excel requirements - original table is much bigger.

 

  • Use conditional formatting to change background color or font color for that one row (based on a flag/measure). For exampe:

    Highlight Row =
    IF (
        SELECTEDVALUE ( 'Table'[Category] ) = "Example",
        1,
        0
    )

    Apply conditional formatting

    1. Select your Table visual

    2. In Values, open the dropdown for the column

    3. Choose Conditional formatting → Background color (or Font color)

    4. Format by: Rules

    5. Based on field: Highlight Row

    6. Rule:

      • If value is 1 → choose highlight color

      • If value is 0 → default color

    This will apply the formatting only to that specific row, without any custom visuals.

3 Replies

  • Use conditional formatting to change background color or font color for that one row (based on a flag/measure). For exampe:

    Highlight Row =
    IF (
        SELECTEDVALUE ( 'Table'[Category] ) = "Example",
        1,
        0
    )

    Apply conditional formatting

    1. Select your Table visual

    2. In Values, open the dropdown for the column

    3. Choose Conditional formatting → Background color (or Font color)

    4. Format by: Rules

    5. Based on field: Highlight Row

    6. Rule:

      • If value is 1 → choose highlight color

      • If value is 0 → default color

    This will apply the formatting only to that specific row, without any custom visuals.

  • Hi Emma_ 

     

    You cannot make a specific row bold or italic in native Power BI Table or Matrix visuals.

     

    Reason: Formatting is column-based, not row-based

     

    Conditional formatting supports:
    Background color
    Font color
    Data bars
    Icons

    Font style (Bold / Italic) is not exposed to conditional formatting

     

    So Power BI simply does not provide an API or UI option to:
    Bold one row
    Italicize one row
    Change font weight dynamically per row

    This is a hard limitation, not a missing trick.

     

    What is possible?
    Simulate emphasis using background + font color

    You can visually “highlight” a row so it stands out clearly.

    Create a flag column or measure
    IsExampleRow =
    IF ( Table[RowName] = "Example", 1, 0 )

    Conditional formatting
    Apply to each column you want:
    Background color → Based on IsExampleRow
    Font color → Based on IsExampleRow

    Ex:
    Example row → Dark background + white text
    Others → Default