I have designed a matrix report with additional databar column. There are many empty cells in the report and I don't want to have different widths of bars in the databar chart but I need to have the same look. When there is 4 data columns in report then databar should have 4 bars independent if the row has values only for one column or for all 4 columns.
On the picture you can see the problem with databar. I would not like to put zeros instead empty values but zeros should be used only in the databar illustration (the zero will be not shown as graphic but it help to preserve the same order of data column in chart of databar)
Is it possible to adapt the data supplied from each row into databar chart in a way that it has always the same qty of values ( and use zeros when empty value in a matrix cell detected) ?