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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Bold text in middle of conditional column

I would like to bold a word [NOT] in the middle of a conditional column, see example below.  Is this possible?

 

Retail Available  *** Distributors NOT Available

1 ACCEPTED SOLUTION
dm-p
Super User
Super User

Hi @Anonymous - I've answered this in your other thread here.

Another possibility (if you want to use the column in a table) is to use a similar technique to that post, but using a site like YayText to get the bold unicode characters for your desired text. Note that this may look weird, as it's not font-specific, but using the Bold (sans) variant might get you close:

dmp_0-1655262827647.png

The measure that we might use is fairly similar, but just replacing with the copied 'bold' text, e.g.:

Bold_Not_Unicode = 
    VAR _Value = MIN(DOH_Prod_List[Product Status])
    RETURN SUBSTITUTE( _Value, "NOT", "𝗡𝗢𝗧", 1 )

And here it is in a table, e.g.:

dmp_1-1655262887947.png

Hopefully might give you some ideas.

Regards,

Daniel





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


On how to ask a technical question, if you really want an answer (courtesy of SQLBI)




View solution in original post

5 REPLIES 5
dm-p
Super User
Super User

Hi @Anonymous - I've answered this in your other thread here.

Another possibility (if you want to use the column in a table) is to use a similar technique to that post, but using a site like YayText to get the bold unicode characters for your desired text. Note that this may look weird, as it's not font-specific, but using the Bold (sans) variant might get you close:

dmp_0-1655262827647.png

The measure that we might use is fairly similar, but just replacing with the copied 'bold' text, e.g.:

Bold_Not_Unicode = 
    VAR _Value = MIN(DOH_Prod_List[Product Status])
    RETURN SUBSTITUTE( _Value, "NOT", "𝗡𝗢𝗧", 1 )

And here it is in a table, e.g.:

dmp_1-1655262887947.png

Hopefully might give you some ideas.

Regards,

Daniel





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


On how to ask a technical question, if you really want an answer (courtesy of SQLBI)




Anonymous
Not applicable

Very COOL worked like a charm!

Anonymous
Not applicable

You can try the Smart Narrative visual

GSun_0-1655172847180.png

 

Anonymous
Not applicable

Thanks but this is a column I am pulling into a table visual.

Anonymous
Not applicable

Sorry, there is no way.

You can do it differently, for example, the whole cell in a different style.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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