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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
zivhimmel
Resolver I
Resolver I

Use Bold characters based on condition

Hi,

Is there any way, in a calculated column or measure, to bold the text if some condition takes place.

Say, if the length of the string is lower than 10, use bold charachters?

Doesn't have to be bold, could be any other way that will make the text stand out.

Thanks.

 

1 ACCEPTED SOLUTION
jdbuchanan71
Super User
Super User

If the string is in a measure you can do it.  In my example [Month_Name] is a measure

Month_Name = SELECTEDVALUE( Dates[Month Name] )

Then I have another measure for the formatting

Month Name Format = IF ( LEN ( [Month_Name] ) <= 5, "Red" )

That gets applied to the [Month_Name] measure.

stringformat.jpg

View solution in original post

2 REPLIES 2
jdbuchanan71
Super User
Super User

If the string is in a measure you can do it.  In my example [Month_Name] is a measure

Month_Name = SELECTEDVALUE( Dates[Month Name] )

Then I have another measure for the formatting

Month Name Format = IF ( LEN ( [Month_Name] ) <= 5, "Red" )

That gets applied to the [Month_Name] measure.

stringformat.jpg

Thanks @jdbuchanan71 !

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

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

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

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

Top Solution Authors