topic Re: Dynamic Format Data Labels in charts in DAX Commands and Tips

Dynamic Format Data Labels in charts

eliasayyy — Mon, 27 Mar 2023 09:40:13 GMT

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

Re: Dynamic Format Data Labels in charts

amitchandak — Mon, 27 Mar 2023 14:21:53 GMT

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)
)

Re: Dynamic Format Data Labels in charts

ewilliams0405 — Tue, 16 May 2023 20:13:37 GMT

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