dynamic format string multiple measures

Hi powerbiexpert22​ - Your format string logic is fine. The labels show M because the format isn’t being applied at all, so the visual is auto-scaling. There are three things to fix:

1. Turn off auto display units on the visual
   In the line and clustered column chart, set Display units = None for:

• Data labels → Values (for all series)
• Y-axis, and the secondary Y-axis if you use one

When this is left on Auto, it overrides dynamic format strings.

2. Commit the format expression on each measure
   The empty formula bar means the expression wasn’t saved. For each of the three measures, select the measure and set Format = Dynamic. Then make sure the formula bar dropdown shows Format, paste the expression, and press Enter. Dynamic format strings are stored per measure, so you need to repeat this for all three. I’d also escape the K and M characters:

VAR _m = [VMAX] RETURN SWITCH ( TRUE (), _m < 1E3, "#,##0", _m < 1E6, "#,##0,.0\K", "#,##0,,.00\M" )

3. Check the VMAX calculation
VMAXCYPLANUSD returns 639,267, but the largest monthly CY Plan value in your table is 199,960. The calculation is probably using ALL(), which removes your year/slicer filters. Try ALLSELECTED over the axis column together with its sort column:

VMAX = MAXX ( ALLSELECTED ( 'Date'[Month], 'Date'[MonthNo] ), MAX ( MAX ( [test_cyactualusd], [test_pyactualusd] ), [test_fyplan] ) )

Once these are in place, all labels should show in K for your current data. If the max goes above 1M, the labels switch to M together.

If this helps, please mark it as the solution so others can find it.