Forum Discussion
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
| Desc | Q1 | Q2 | Q3 | Q4 |
| Apple | 10 | 30 | 10 | 30 |
| Orange | 20 | 23 | 20 | 20 |
| Banana | 30 | 25 | 30 | 10 |
| Pineapple | 44 | 43 | 44 | 30 |
5 Replies
- Ritaf1983
Super User
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-281878bd1a87If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
- MattiaFratello
Super User
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 wellDid I answer your question? Mark my post as a solution!
- danextian
Super User
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.
- AnonymousNot 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.
- AnonymousNot 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!