cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TGM
Helper I
Helper I

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 @TGM - 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!


My course: Introduction to Developing Power BI Visuals


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 @TGM - 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!


My course: Introduction to Developing Power BI Visuals


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




Very COOL worked like a charm!

GSun
Resolver III
Resolver III

You can try the Smart Narrative visual

GSun_0-1655172847180.png

 

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

GSun
Resolver III
Resolver III

Sorry, there is no way.

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

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.