Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

Reply
Anonymous
Not applicable

Matrix/Table formatting - BOLD row

Hi,

 

Need help in  formatting one row to be bold in the Matrix.

I ca use a table too...

 

ItemsValue
A10
B20
C30
D10
E10
Total80

 

Thanks

2 ACCEPTED SOLUTIONS
rajendraongole1
Super User
Super User

Create a basic measure to give the row you need highlighted a value and then apply conditional formatting with a rule.

 

For example if i had this table:

 

ExampleV 1V 2
A15
B26
C37
D48

 

suppose i wanted the row with all 'D' to be highlighted, i could create the following measure:

 

Measure = IF(Table[Example] = "D", 1, 0)

 

I can then apply the conditional formatting for each column using the rule and value =1

 

In conditional format use the rule and call that measure.

 

Regards,

Rajendra





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

Proud to be a Super User!





View solution in original post

Anonymous
Not applicable

I used Calculated column instead of measure and it worked.

Thanks for your help

View solution in original post

8 REPLIES 8
Anonymous
Not applicable

It is now almost 2024.   We have flying cars now.   Did Microsoft create a way for people to bold a row in a table in their highly touted Power BI application???

Pascal_KTeam
Resolver I
Resolver I

If you have an Excel table with specific formatting that you want to bring to Power BI, watch this video where it is explained how this can be done: 

 

How to create any Excel table in Power BI using the HTML & CSS Viewer Visual
https://youtu.be/6JYVqE4UK7M

rajendraongole1
Super User
Super User

Create a basic measure to give the row you need highlighted a value and then apply conditional formatting with a rule.

 

For example if i had this table:

 

ExampleV 1V 2
A15
B26
C37
D48

 

suppose i wanted the row with all 'D' to be highlighted, i could create the following measure:

 

Measure = IF(Table[Example] = "D", 1, 0)

 

I can then apply the conditional formatting for each column using the rule and value =1

 

In conditional format use the rule and call that measure.

 

Regards,

Rajendra





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

Proud to be a Super User!





Conditional formats for tables and matrices do not include bold, italics, or font size/style (with the exception of font color). It seems as though the original post has not been addressed. Google results are scant on this topic.

I followed the mentioned steps, but am not aware on how to apply the bold format tp the entire row based on the measure created? can any one help on this?

@rajendraongole1 

Is it possiable to Bold whole row in the Matrix/Table formatting?
I want to make it bold for whole WW row.
10.PNG

Thank you

 

Regards,
Hari 

Anonymous
Not applicable

I used Calculated column instead of measure and it worked.

Thanks for your help

Anonymous
Not applicable

Ended up with background color instead of BOLD text for the above issue

Helpful resources

Announcements
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.