Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Dynamic format not working for stacked column chart

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 fo...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Anonymous ,

     

    Thanks for Tahreem24 reply, that's really helpful!

     

    Anonymous 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