I am building dashboard for Sales values. There is no data for Oct, Nov, Dec. I'd like to show on chart these months labels, even though there are no values for these months.
If I use 'Show Empty Columns' functionality it is working fine. However, I am considering performance in a large manner. When using 'Show Empty Columns' functionality there is additional query sent which negatively impacts the performance.
I am wondering if there is any other way (workaround) to solve this problem ie. to show 'no data' for Oct, Nov, Dec without using 'Show Empty Columns' functionality?
Try converting it to a continuous month field and then updating the axis, please see my response here: