Graph builder removes levels of a variable when adding a local data filter (and I don't want it to)

[#1]

I have some categorical data (a Likert scale) with 5 levels, with some responses at each level. When I add a local data filter, one of the levels no longer has any responses, and then this level doesn't show up on the graph anymore, but I want it to (with a bar of size 0).

No filter:

With filter (notice "Somewhat unhappy" [second level from top] is now missing):

I have "Include Missing Categories" checked, but that doesn't change anything. I also set the Value Order for this variable (including all 5 levels), but that doesn't seem to change anything either:

I found a few related questions, like this one which is my problem in reverse, and this one which seems to work for continuous variables but I can't figure out how to make it work with my data and Graph Builder.

Thanks!

[#2]

Hmm, odd behavior.

Maybe try checking this option from the red triangle menu?

[#3]

Yep, it's checked (I've tried it both checked and unchecked):

[#4 · Accepted solution]

You might have to enable show excluded rows (hold shift and click on the red triangle of graph builder) if your local data filter is in Include mode

[#5]

Oh man, another hidden option!  Why JMP has this secret options that only holding shift will reveal is beyond me!

[#6]

Yes, that did it! Thank you so much!

Agreed with @shampton82 that it's bizarre that this option is hidden... I never even knew about the "hold shift to show more options" thing.

[#7]

There's a reason your rows are disappearing.  The local-data-filter is eliminating all rows that don't meet its criteria, so at that point the Graph Builder plot doesn't even know that category value exists.  Sometimes we'll put in fake data to make the category rows appear when we're doing these types of filtering actions. 

Note, I know about the Show Excluded Rows option, but it's not always clear what it's doing.

[#8]

Here is a collection of easter eggs which are hidden behind a  CTRL/Alt/Shift + click/select/double click/right click .

I updated the entry for Show Excluded Rows and added a link *) to this discussion.

All the secrets and workarounds in JMP are great : )
but actually, for many of them them it would be better if the functionality was just there - without secrets or workarounds:

Here is a collection of wishes with the goal of making life easier for new - and experienced - JMP users:
Wish list - new Label: user experience 

*) sure: a secret link

Nice talk on Secret Features of JMP .

[#9]

For JMP <=18 you still can use another "workaround" :

For the column on the axis, change the  modeling Type to  Multiple Response .Then all items will show up on the axis:

Graph Builder: adjust the axes to the filtered data 

NB: Don't combine this workaround  with Show Excluded Rows. It will disable the effect.

Names Default to Here(1);
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
Data Table( "Big Class" ):name << Set Modeling Type( "Multiple Response" );
Graph Builder(
	Variables( X( :name ), Overlay( :sex ) ),
	Elements(
		Bar( X )
	),
	Local Data Filter(
		Show Modes( 1 ),
		Add Filter( columns( :sex ), Where( :sex == "F" ) )
	)
);