Auto Units in Column Chart vs. Line Chart

[eradcliffe]

I have a business requirement to dynamically change the display of a Data Label in a bar chart. When the valu is >= 10,000 it should be displayed with a thousands unit, like 10k, 20k, 50k, 100k, 1000k, etc. When it is less than 10,000 it should be the whole number, 600, 700, 900, 1000, etc.

In a Clustered Column chart, having Display Units = "Auto" it shows 205k, 210k, 150k, etc as expected. However, when filtering the dashboard down to smaller number, like 23, the data label doesn't update to consider the smaller numbers. It shows 0.0K

This is in stark contrast to a line chart. A line chart will display as 205k, 210k, 150k and then when filtering to a smaller number like 23, it automatically updates and shows the whole number 23 instead of 0.0k

1.) The different behavior between the two visuals seems unexpected. Is this a known defect with clustered column chart?

2.) Is there a solution/workaround for this in a clustered column chart at this time?

[v-xiaotang]

Hi @eradcliffe 

Have you solved this question? If you have solved the question, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.

If you need more help, please let me know.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[v-xiaotang]

Hi @eradcliffe 

Please check your settings, the units of label is able to change automatically in clustered column chart

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[VahidDM]

Hi @eradcliffe 

Try a measure like this:

Measure = 
Var _A = sum('Table'[Column2])+980
return
if(_A>=1000,FORMAT(_A,"#,##0,K"),_A)

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[eradcliffe]

You can't plot a string in a column chart. I tried a similar approach, but it's not suitable.