Forum Discussion

AL_Thomas's avatar
AL_Thomas
Frequent Visitor
1 year ago
Solved

Highlight specific rows bold

Hi all,

     I am trying to create a Profit and Loss statement in Power BI and have successfully created one using a template i designed in excel and pulled it into Power BI. Used Variables to do the calculations for each line item on the P&L Template. However, there are certain rows in my table that i want to Highlight and Bold. But i cannot find any option for it. What i am trying to do is highlight the subtotals field name and results. 

 

Thanks,

  AL Thomas

  • Ritaf1983's avatar
    Ritaf1983
    1 year ago

    Yep, you are right , the options is available only for matrixes...
    As an alternative in a table, you can apply a light background color with conditional formatting.

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

     

4 Replies

  • AL_Thomas's avatar
    AL_Thomas
    Frequent Visitor

    Thank you for the reply. Unfortuantely, i am using a table instead of the matrix. The table itself is a excel template i pulled into power bi so i could show the indentations and blank row spaces after certain accounts just to make it look like a proper P&L Statement.

    I suppose there is no way to Bold it in table

    . Is there a way to highlight it? I looked at conditional formatting and was able to conditionally format the column name to specific color, but where i try to do it for the value, it highlights the entire column with the color.

    • Ritaf1983's avatar
      Ritaf1983
      Super User

      Yep, you are right , the options is available only for matrixes...
      As an alternative in a table, you can apply a light background color with conditional formatting.

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

       

      • MT-Aung's avatar
        MT-Aung
        New Member

        Hi Rita, There is no option for "Specific Row" like "Specific Column". If you have solution, rather than applying to "Row Subtotals", can you please share?