Dynamic formatting for the values

Anonymous , Auto should be the best option.

Refer this example for currency, But you can use same based on measure value - https://radacad.com/dynamically-change-the-format-of-values-in-power-bi

Hi Anonymous ,

To my knowledge, Power BI does not support conditional formatting for Data labels currently. The only changes you can make to label formatting for measures are the following:

I suggest you use the following formula for Tooltip instead:

Measure =
SWITCH (
    TRUE (),
    MAX ( 'Table'[Value] ) >= 1000000, FORMAT ( MAX ( 'Table'[Value] ), "#,##,,.0M" ),
    MAX ( 'Table'[Value] ) < 1000000
        && MAX ( 'Table'[Value] ) >= 1000, FORMAT ( MAX ( 'Table'[Value] ), "#,##,.0K" ),
    MAX ( 'Table'[Value] ) < 1000, MAX ( 'Table'[Value] )
)

The output is shown below:

Please take a look at the pbix file here.

In addition, I think this is at idea/feedback level alone. May be , hopes Power Bi will implement this in nearby future.

If you also want this in power bi, let the power bi community to know this things and give your votes at power bi site's feedback-

https://ideas.powerbi.com/ideas/idea/?ideaid=eace23e5-1dbc-493c-9644-0854ee0a19ba

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.