Lack of Drill-Down in Column Chart Report with Value of '0'

Good morning everyone,

I’m writing to see if anyone has any tips for the following - 

I’ve made a bar report to show a metric for each of our CSMs, and several of the data points displayed are 0. There are records for these data points (the value just averages out to 0), but the lack of column prevents drill-down, as far as I can tell.

I know using a line chart format overcomes this issue but as the report is not ‘over time’ I was hoping that there’s a workaround without using this. Any help would be greatly appreciated.

Thank you! 

Grace