Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Specific Rows to highlight / Bold in Metrics report

I have multiple rows so i wanted to highlight on specific rows on Bold and color example like

pls suggest

DescQ1Q2Q3Q4
Apple10301030
Orange20232020
Banana30253010
Pineapple44434430

 

 

 

5 Replies

  • Hi Anonymous 
    Unfortunately, we don't have an option for bold formatting for specific rows except for totals and sub-totals in matrixes.
    For conditional formatting, you can use a font and/or background colors.
    There is an idea about this issue, please vote for it (I voted 🙂 ) :
    https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=99012dc3-af1f-ec11-b76a-281878bd1a87

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

  • You can do that by using conditional formatting.

    IF Desc = Banana then ...

    But you can't use bold, you may want to use a different text color or background

    You will have to repeate if for the numbers as well

     

    Did I answer your question? Mark my post as a solution!

  • Hi Anonymous 

     

    Your sample appears to be a matrix.  Conditional formatting is currently supported for values only - no column or row categories - and are limited to font/fill color, data bars and icons only. Formatting a value as bold is currently not an option unless you render those values as SVG images.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi,

    Thanks for the solutions danextian , Ritaf1983  and MattiaFratello  offered, and i want to offer some more information for user to refer to.

    hello Anonymous , As other partners have said, conditional font settings are not supported in the matrix. Perhaps you can consider setting the background color of the matrix. You can refer to the following solution.

    Sample data 

    Create a measure

    Measure = IF(SELECTEDVALUE('Table'[Desc])="Banana","red")

    Then create a matrix visual, and set the background in conditional formatting for the value.

    Put the measure to it.

    Output

    Best Regards!

    Yolo Zhu

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi,

      Its working me aswell as we need in Banana also in Red color, basically entire rows.

      the conditional formatting works in value not in text, do you find any solution.

       

      Thanks!