Forum Discussion

zivhimmel's avatar
zivhimmel
Icon for Resolver I rankResolver 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...
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.

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper 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.