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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! 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
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors