Chart display units set automatically based on data

When using a chart to represent relatively large numbers, the K or M separator is used to better visualise the numbers.

However, when users filter the data and smaller numbers are displayed the separator remains and then no number is shown. The result is that the number is displayed as 0k or 0M.

It would be helpful to have an auto setting so the display units adapt based on the magnitude of the data values displayed in the chart.