Details on Advanced Settings

To reach the Advanced Settings dialog:

In the Visualization Properties dialog, go to the page of interest (for example, X-axis, Y-axis, Trellis...).
Click on the Settings... button next to the column selector of the property of interest.

Option	Description
Axis mode	Specifies whether the column or hierarchy should be treated as continuous or categorical.
Continuous	Select this option for numerical columns when you want the values to be treated as continuous, numerical values. This option is not available for properties that are always categorical (like string columns).
Categorical	Select this option when you want the values to be seen as categories rather than numerical values. For example, if you have the years 2001, 2002 and 2003 in a column, you would probably like to treat the different values as categories rather than numbers.
Categories	Determines how to display the categories.
Show filtered values	Select this option to display values currently available after any filtering operations only. This means that those categories that are visible will change when filtering and that categories currently without any values will be hidden from the visualization.
Show filtered range	Select this option to hide empty categories on both ends of the currently visible range. This means that those categories that are visible will change when filtering, and that empty categories within the currently visible range will remain visible.
Show all values	Select this option to keep all categories visible even if data for some categories have been filtered out.
Show/Hide hierarchy options	For hierarchical categories only, but not available for Date, Time or DateTime hierarchies. Shows or hides the options used to specify how hierarchies should be built, that is, which combinations of the different categories should be available.
Specify how to combine column values in the hierarchy	Specifies how many categories will be available, e.g., on an axis or in a list of colors in the legend.
Use actual combinations in data only (nest)	Use this option to display all combinations available in the data. For more information about the nest and cross alternatives, see General Syntax.
Use all possible combinations (cross)	Use this option to display all possible combinations, even showing categories that are currently not included in the data.