Table Call Value Formatting Options

[miitch]

In both the documentation in Learn as well as blog posts, I'll see text formatting that I cannot for the life of me find in either desktop or the service. 

For example, in the sample images on this page for tables, there are tables with cells that have only the text highlighted, rather than the full cell background. 

This image specifically, you can see that the "Pending" text in the "Status" column only has the text highlighted blue, while the row background color (grey) is still visible as well. 

This is a formatting feature I would love to have, but I can't find. I'm at the point where I don't think it's possible, but I see this exact style for formatting so frequently in examples provided by the team that I'm wondering if I'm just missing something?

[danextian]

Hi @miitch 

It looks like the contents of the Status column are DAX-generated SVG images as if they were background conditional formatting, they would have filled the entire cell and not just a portion of it. 

Below is a sample measure I used in the status buttons above. This measure is to be categorized as an Image URL

Status SVG Button = 
VAR _Text = [Status Measure]

VAR FillColor =
    SWITCH (
        [Status Measure],
        "Value A", "#ffb09c",
        "Value B", "DeepSkyBlue",
        "Value C", "#FFFFE5",
        "#D3D3D3"
    )

VAR FontColor =
    SWITCH (
        [Status Measure],
        "Value A", "black",
        "Value B", "white",
        "black"
    )

VAR StrokeWidth =
    IF ( [Status Measure] = "Value C", 2, 0 )

VAR _SVG =
    "<svg xmlns='http://www.w3.org/2000/svg' width='200' height='70'>
        <rect 
            x='0' 
            y='5' 
            width='200' 
            height='56' 
            rx='10' 
            ry='10' 
            fill='" & FillColor & "' 
            stroke='#e5e500' 
            stroke-width='" & StrokeWidth & "' 
        />
        
        <text 
            x='100' 
            y='38' 
            font-size='30' 
            font-family='Arial' 
            fill='" & FontColor & "' 
            text-anchor='middle' 
            dominant-baseline='middle'>
            " & _Text & "
        </text>
    </svg>"

RETURN
    IF (
        HASONEVALUE ( d_Dimension[Attribute] ),
        "data" & ":" & "image/svg+xml;utf8," & _SVG
    )

[v-sshirivolu]

Hi @miitch ,
This behavior isn’t actually a native text-only highlight feature in Power BI tables. The built-in Table visual supports formatting at the cell level rather than directly behind individual text values.

The effect shown in many documentation screenshots is usually achieved through a combination of alternating row background colors, conditional background color formatting on the cell and tighter column sizing that makes the colored cell appear closer to the text itself.
Because of that, it can visually look like only the text is highlighted even though the entire cell is being formatted.

If you are looking for a true tag/pill-style highlight where the background wraps only the text itself, standard table/matrix visuals currently do not provide that capability directly. For that type of formatting, custom visuals such as Deneb or HTML-based visuals are typically required.

[Shai_Karmani]

You're looking for the Font color rule under conditional formatting, not Background color. Select the table or matrix visual, expand Cell elements in the format pane, pick the field you want to format from the dropdown, then toggle Font color on and click the fx button to set it by rules, gradient, or field value. That changes only the text color and leaves the row background untouched, which gives you the highlight look you see in those docs screenshots.

If this helped, a thumbs up and accepting the solution would be appreciated.

Thanks,
Shai Karmani

Let's connect in LinkedIn

[miitch]

Thanks for the response! 

Unforuntaly I think you misunderstood. The look in the example image I am trying to recreate is not just the blue font color, but the light blue highlight behind the text. 

You can see that while the font is blue, the text also has it's own background color that sits on top of the row background color. The issue being, font color only changes the text to blue, and setting "Background color" fills the entire cell and replaces the row background color.

[miitch]

Thanks for the response! Unfortunately I think you misunderstood.

Setting the text color is not the issue. As you can seen in the screenshot, the text itself is not only blue, but is hightlighted light blue as well. 

In the image, you can see that for the second row, the Status cell has blue text, the text is highlighted blue, and the row background remains grey.