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
skedis
Helper I
Helper I

How to Conditional Format text in a Text Box

Hello everyone,

 

I have  3 columns - name, load_time, increment, flag (flag is Y if load_time >2, else N)

I have a text box that displays name & load time similar to below based on dynamic value's of their increment value 

 

skedis_1-1698449455771.png

In yellow, is how i'm pulling in the information. 

skedis_3-1698449781756.png

If load time is greater than 2s (where flag is Y), I want to change the font to red. How can I do this? Thank you in advance for your time and expertise.

 

 

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @skedis 

You can use a card instead of the text box.
1. Create a measure with the needed text :

text test = "bla bla bla"
2. put it on the card and switch the category label off
Ritaf1983_0-1698461355974.png

3. modify the conditional formatting of the callout value according to the flag measure

Ritaf1983_1-1698461472997.png

Result:

Ritaf1983_2-1698461519123.pngRitaf1983_3-1698461542326.png

You can download the linked file and follow my steps

If this post helps, then please consider Accepting it as the solution to help the other

members find it more quickly.

 

View solution in original post

3 REPLIES 3
Ritaf1983
Super User
Super User

Hi @skedis 

You can use a card instead of the text box.
1. Create a measure with the needed text :

text test = "bla bla bla"
2. put it on the card and switch the category label off
Ritaf1983_0-1698461355974.png

3. modify the conditional formatting of the callout value according to the flag measure

Ritaf1983_1-1698461472997.png

Result:

Ritaf1983_2-1698461519123.pngRitaf1983_3-1698461542326.png

You can download the linked file and follow my steps

If this post helps, then please consider Accepting it as the solution to help the other

members find it more quickly.

 

Thank you so much, this worked! 

@skedis 
Glad to help 🙂

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.