Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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.
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.
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/
You can't plot a string in a column chart. I tried a similar approach, but it's not suitable.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |