Showing all x-axis values even when no associated data

building reports desktopintelligence
1

Have searched the forum, read the tech manual etc. but still can’t figure out how to force a chart to display all values when a filter is applied that means there aren’t any values for a particular axis element.

e.g. Full chart show months jan - dec on x-axis. When chart is filtered for a particular product for which there were no sales in feb and april, the x-axis changes and doesn’t show feb and april.

gpn01 :uk: (BOB member since 2004-11-30)

2

Create a seperate query for all your dates, link / merge with your other query then use these as the basis for your axis along with your measure from the other query…

Mak 1 :uk: (BOB member since 2005-01-06)