Forum Discussion
Auto Units in Column Chart vs. Line Chart
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?
4 Replies
Hi Anonymous
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/Hi Anonymous
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.
Hi Anonymous
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.
