Dynamic format not working for stacked column chart

[FrancoPowerBi]

Greetings,

I'd like to show the number in the data label as millions when it's over 1M and as K when it's below that number. I've confirmed the numbers display as I wish when I put the dynamic format measure in a draft table. 

Desired result

I need to use this measure as a data label for the light blue columns in the following graph. However, when I try to do it I get this

Obtained result

These are the settings I'm using for the data label. Just in case, my dynamic format measure is just the data label. The light blue column is a different measure I'm using as a placeholder.

Settings chosen

I could think of a workaround using two measures and giving them different fixed units (K and M), but I'd like to know whether this is a bug or something I'm not understanding correctly.

Thanks in advance.

[v-mengmli-msft · Accepted solution]

Hi @FrancoPowerBi ,

Thanks for @Tahreem24 reply, that's really helpful!

@FrancoPowerBi How do you create the measure? Here is my test for your reference.

Measure = VAR SV = SELECTEDVALUE('Table'[Value])
RETURN  IF(SV>1000000,ROUND(SV/1000000,1)&"M",ROUND(SV/1000,0)&"K")

If you just want use this measure as a data label for the light blue columns,  you can apply the setting to series of light blue column.

Best regards,

Mengmeng Li

[Tahreem24]

@FrancoPowerBi  You can refer this video. It has the solution which you're looking.

https://www.youtube.com/watch?v=s4jeX9EKON4