Dynamic Format Data Labels in charts

[eliasayyy]

hello everyone , 
i have a facebook ads by campaign table

Campaign	Impressions
Camp A	1500000
Camp B	100500
Camp C	1000
Camp D	10000

i want to make a  column chart that will show me the campaign in the x-axis and measure of Total impressions
Total impressions = sum(table[impressions])

when i turn on data labels , i want to show a dynamic data label

so if number is in millions it will return 1.00M if the numbe rin thousands then it will return 1.00k

so new format should be i will show in table for better context

Campaign	Impressions
Camp A	1.5M
Camp B	100.5k
Camp C	1.00K
Camp D	10.00K

[amitchandak · Accepted solution]

@eliasayyy , Try like

SWITCH ( TRUE() ,
[Impressions]>= 1000000000 , FORMAT ([Impressions]/1000000000, decimal) & "bn" ,
[Impressions]>= 1000000, FORMAT ([Impressions]/1000000, decimal) & "M" ,

[Impressions]>= 1000, FORMAT ([Impressions]/1000, decimal) & "K",
FORMAT ([Impressions] , decimal)
)

[ewilliams0405]

Actually with the dynamic formating you don't need to use division.

SWITCH(TRUE(),

ABS([val]) >= 1000000, "\$#,0,,.0M;(\$#,0,,.0M)"

ABS([val]) > 100000,"$#,0,.0k;($#,0,.0k)"

,"#,0;(#,0)")

I have noticed with trying to get K to work without a decimal using, 

"\$#,0,.k;(\$#,0,.k)" the values that appear in the data label is not correct but the value shown in tables and in the tool tip is corrrect.  I have no Idea why but if someone knows a solution please let me know.  

Jack