I have a bar chart that is showing a measure, trended over month and year dimensions. There is a dummy "=1" dimension on the chart also used to prevent the months being stacked on the chart.
I want all of the chart values to be displayed at all times, even if the user adds a filter that will take a month value to zero i.e. all years and months are shown even if there aren't any values for them in the selection.
To achieve this, I have ticked the "Show All Values" option on the "Year" and "Month" dimensions and also unticked the "suppress zero values" on the Presentation tab of the chart properties.
So far so good - everything works how I want it... however an extra null (shown by "-" symbol) value for the year dimension has appeared from somewhere that I cannot remove.
I have created attached an application to demonstrate the problem. Can anyone assist me with this problem?
Thanks yaseen but I have tried this already. When you do this and then filter on "snickers" in my example, the month of March disappears. This is because there are no sales for snicker in march, but I would still like this value to appear on the chart.