Format STRING text for colour and italics

[Niiru1]

Is there a way for format colour and font in the same measure?

1. Search for specific text in STRING  e.g. "Table 3." in "Table 3. This table represents all of my sample data. Data source Datamart"

2. Search for specific text in STRING  e.g. "Data source Datamart" in "Table 3. This table represents all of my sample data. Data source Datamart" and FORMAT it to make it Italic

E.g. Measure

Title Table 3. =

VAR _Text = "Table 3. This table represents all of my sample data. Data source Datamart"

RETURN

SWITCH(TRUE(),VALUE(_Text) = "*Table 3.*","#094")

[Fowmy]

@Niiru1 

Your question is not clear enough for me. If you need to check if certain text exists in a given text then try like:

E.g. MeasureTitle Table 3. = 
VAR _Text = "Table 3. This table represents all of my sample data. Data source Datamart"
RETURN
SWITCH(
    TRUE(),
    CONTAINSSTRING(_Text,"Table 3."),"Found", 
    "#094"
)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Niiru1]

This works for returning found but is there a way to return the full _Text string with just "Table 3" colour changed?

Something like:

SWITCH(

TRUE(),

CONTAINSSTRING(_Text,"Table 1"),_Text,"094")

[TomMartens]

Hey @Niiru1 ,

it's currently not possible to add color or other formatting options to a partial string.

You can create an idea here: Ideas (powerbi.com)

Regards,

Tom