Sorry if I'm missing something basic here.

As the title says, I'm trying to show progress against targets with a bullet graph.  My data has an 'achievement' measure and I've joined a table with targets, also as a measure.  There are 7 categories in a dimension field (think groups whose performance I want to show) which I'm using on the row shelf to create 7 different bullets.

I would like to show each of the 7 categories even if the group hasn't achieved any 'sales'.  At the moment I can only get it to show a group if the achievement measure isn't null.  Of course the target still exists even before the first 'sale'.

What am I doing wrong?