Changing value type within a measure just for display

[RMDNA]

Hi all,

I'm creating in-table KPIs using a mesaure in order to add a colored box inside the cell (and avoid the full-cell color background).

Spoiler

The measure to create this visual is below:

Spoiler

New Accounts_WTD % #/KPI =
VAR Indicator =
    IF (
        [New Accounts_PL % WTD] >= 1.1,
        UNICHAR ( 128215 ),
        IF (
            [New Accounts_PL % WTD] < 0.9,
            UNICHAR ( 128213 ),
            IF ( [New Accounts_PL % WTD] >= 0.9, UNICHAR ( 128210 ), UNICHAR ( 128211 ) )
        )
    )
RETURN
    IF (
        [New Accounts_PL % WTD] <> 0,
        FORMAT ( [New Accounts_PL % WTD] & " " & Indicator, 0 ),
        0
    )

As you can see from the picture, the values are displayed as a number - what I need is to get it to display as a %. The measure is set to display as a %, the field referenced in the calculation is a %, and it's set to % in Field Formatting, but it always stays as a number.

Is it possible to set the output format within the measure, or will it always default to a number?

[Anonymous · Accepted solution]

Can you nest formats like such?

FORMAT ( FORMAT([New Accounts_PL % WTD],"Percent") & " " & Indicator, 0 )

Hope this helps,

Parker

[RMDNA]

@Anonymous,

That seems to work (at least in initial testing); is there a way to specify how many decimals places are used?

[Anonymous]

I've never done it but apparently it can be done with the FIXED function.

FIXED(<number>, <decimals>, <no_commas>)