Forum Discussion

zivhimmel's avatar
zivhimmel
Resolver I
7 years ago
Solved

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.

 

Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    7 years ago

    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.

2 Replies

  • jdbuchanan71's avatar
    jdbuchanan71
    Super User
    7 years ago

    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.