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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Post Prodigy
Post Prodigy

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

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
skang
Frequent Visitor

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
Post Prodigy
Post Prodigy

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

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.