Hi,
I would like to set a global x-axis in a table bar chart, currently I have something like this:
But the bars are different sizes because for some rows there is not data for some of the days. I would like the x-axis to be uniform across the rows and all the bars to be aligned and showing gaps where there is no data.
I use a canonical calendar and normally deal with this issue by adding '+sum(0)' to the measure, however this is not working when the bar chart is inside a table.
Please, let me know if you have any ideas how to solve this.