Dynamic Number Format 07-07-2024 21:31 PM

[aduguid]

This can be used after selecting the "Dynamic" as the measure format under "Measure tools"

VAR CurrentValue = SELECTEDMEASURE()
RETURN
    SWITCH (
        TRUE (),
        // format the number based on value
        CurrentValue <= -1E6, "#,0,,.00 M",
        CurrentValue <= -1E3, "#,0,.00 K",
        CurrentValue <= 1E3, "#,0.00",
        CurrentValue < 1E6, "#,0,.00 K",
        CurrentValue < 1E9, "#,0,,.00 M",
        CurrentValue < 1E12, "#,0,,,.00 B"
    )

I