Formatting new card visual

Hi Babu34 ,

You can't directly format different parts of a single measure's text output with different styles, like bolding one word and coloring another. This is because Power BI's formatting options in a standard visual apply to the entire text field, not to individual words or characters within it.

The most straightforward workaround is to use multiple, smaller Card (new) visuals and then group them. You would use your main card for the "total amount collected." Below it, place a small card with a measure that returns only the previous year; you can format this card's callout value to be bold. Next to it, add another small card with a measure for just the YoY variance percentage. You can then apply conditional formatting to this specific card's value, making it green if the variance is positive and red if it's negative. Once they are arranged, select all the visuals, right-click, and group them to make them behave as a single object.

A more advanced but powerful method is to write a DAX measure that generates an SVG image. This approach gives you precise control over the formatting of each text element. The measure dynamically creates an image containing your text with the desired bolding and conditional colors.

Formatted Previous Year Label =
VAR PreviousYear = MAX('Date'[Year]) - 1
VAR PreviousYearAmount =
    CALCULATE(
        [Total Amount Collected],
        SAMEPERIODLASTYEAR('Date'[Date])
    )
VAR Variance = ([Total Amount Collected] - PreviousYearAmount) / PreviousYearAmount

-- Format the values as text
VAR PreviousYearText = FORMAT(PreviousYear, "0")
VAR PYAmountText = FORMAT(PreviousYearAmount, "$#,##0K")
VAR VarianceText = FORMAT(Variance, "+0.0%;-0.0%;0.0%") -- Shows + for positive

-- Determine the color for the variance
VAR VarianceColor = IF(Variance > 0, "green", "red")

-- Construct the SVG code as a text string
VAR SVG_Code = "
<svg xmlns='http://www.w3.org/2000/svg' width='250' height='30'>
    <text x='0' y='15' font-family='Segoe UI' font-size='12' font-weight='bold' fill='black'>"
    & PreviousYearText &
    "</text>
    <text x='50' y='15' font-family='Segoe UI' font-size='12' fill='grey'>"
    & " | " & PYAmountText & " | " &
    "</text>
    <text x='150' y='15' font-family='Segoe UI' font-size='12' font-weight='bold' fill='"
    & VarianceColor &
    "'>"
    & VarianceText &
    "</text>
</svg>
"

-- Return the SVG string with the required data image header
RETURN "data&colon;image/svg+xml;utf8," & SVG_Code

After creating the DAX measure above, you need to set its Data category to Image URL in the Model view. Then, instead of placing it in a card's label, you add this measure to a Table visual. The table will render the SVG code as the custom-formatted image you designed. You can then resize this table and place it beneath your main card to achieve the desired look.