Bar chart - how do you change value from billions til millions?

[Anonymous]

Hi,

The bar charts says 0,22 and 0,25 billions and I want it to show 220 and 250 millions instead. If it was a KPI, I could change it under indicator, but that isn't possible, when its a bar chart, unfortunately. 

Best regards Jonas

[Sadapa07]

Click on your Visual -> Go to Paint Brush -> select Axis (X-axis or Y-axis) -> select the drop down of Display option and change from Billions to Millions.

[jthomson · Accepted solution]

If you click on the formatting paintbrush on your visual, you can select either the axis or the data labels and amend the display units from there

[Yogesh_NMH]

Is it possible to set this feature dynamically? I mean, depending on a slicer, show values in the graph as millions or billions. I've seen that, if I use the FORMAT function, it automatically converts the measure into a TEXT, so the graph does not recognise it as a value.

[splambo]

This is a clear decription of PowerBI's frustrating limit regarding dynamic detail labels on charts. I am amazed there isn't a way to control the number formatting dynamically on chart labels, and I hope we can request this to Microsoft?

Strange that the question has been marked as solved when it hasn't 😞