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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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!


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


My course: Introduction to Developing Power BI Visuals


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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors