Visualization Properties in Expressions


In some cases, you may want to use the expression or the display name currently set on an axis as a dynamic part of another expression, so that it changes with your selections. For example, this may be interesting in a visualization title or in a tooltip or label. You may also want one axis to be automatically set to use the same expression as the one set on another axis.

There are a number of different "axis expressions working like properties" available in the visualizations. These properties exist only in the context of a visualization and they have values that are defined by the currently used settings in the visualization. For example, a scatter plot can expose the display name of its X and Y-axis expressions as properties and these can in turn be used to set the visualization title.

The syntax to use is ${Axis.Axis Name.DisplayName} and ${Axis.Axis Name.Expression}, for the display name and the underlying expression, respectively. For example, if the Axis Name is "X", the expression should refer to ${Axis.X.DisplayName} or ${Axis.X.Expression}. Note that the actual axis names to use may be different in two similar looking visualizations, see below. The ${DataTable.DisplayName} property can be used in all visualizations to retrieve the name of the main data table used in the visualization.

These properties can be used the same way as other types of properties. See Properties in Expressions for more information. All of the display name-properties listed below also have a corresponding property for the actual expression.

Visualization

Axis Name Used in Expression

Axis (Property) it Represents

[All visualizations]

DataTable.DisplayName

The name of the main data table used in the visualization

Cross Table

Axis.Columns.DisplayName

Axis.Measures.DisplayName

Axis.Rows.DisplayName

Horizontal axis

Cell values

Vertical axis

Graphical Table

Axis.Rows.DisplayName

Graphical table rows

Bar Chart

Axis.Color.DisplayName

Axis.Columns.DisplayName

Axis.Pages.DisplayName

Axis.Panels.DisplayName

Axis.Rows.DisplayName

Axis.X.DisplayName

Axis.Y.DisplayName

Color by

Trellis columns

Trellis pages

Trellis panels

Trellis rows

Category axis

Value axis

Line Chart

Axis.Line.DisplayName

Axis.Color.DisplayName

Axis.Columns.DisplayName

Axis.Pages.DisplayName

Axis.Panels.DisplayName

Axis.Rows.DisplayName

Axis.X.DisplayName

Axis.Y.DisplayName

Line by

Color by

Trellis columns

Trellis pages

Trellis panels

Trellis rows

X-axis

Y-axis

Combination Chart

Axis.Color.DisplayName

Axis.Columns.DisplayName

Axis.Pages.DisplayName

Axis.Panels.DisplayName

Axis.Rows.DisplayName

Axis.X.DisplayName

Axis.Y.DisplayName

Color by

Trellis columns

Trellis pages

Trellis panels

Trellis rows

X-axis

Y-axis

Pie Chart

InnerAxis.Color.DisplayName

InnerAxis.SectorSize.DisplayName

Color by

Sector size by

Scatter Plot

Axis.Color.DisplayName

Axis.Columns.DisplayName

Axis.Marker.DisplayName

Axis.Pages.DisplayName

Axis.Panels.DisplayName

Axis.Rows.DisplayName

Axis.Size.DisplayName

Axis.X.DisplayName

Axis.Y.DisplayName

InnerAxis.Color.DisplayName

InnerAxis.SectorSize.DisplayName

Color by

Trellis columns

Marker by

Trellis pages

Trellis panels

Trellis rows

Marker size by

X-axis

Y-axis

Pie sector color

Pie sector size

3D Scatter Plot

Axis.Color.DisplayName

Axis.Columns.DisplayName

Axis.Marker.DisplayName

Axis.Pages.DisplayName

Axis.Panels.DisplayName

Axis.Rows.DisplayName

Axis.Size.DisplayName

Axis.X.DisplayName

Axis.Y.DisplayName

Axix.Z.Display.Name

Color by

Trellis columns

Marker by

Trellis pages

Trellis panels

Trellis rows

Marker size by

X-axis

Y-axis

Z-axis

Map Chart

Axis.Color.DisplayName

Axis.Columns.DisplayName

Axis.Marker.DisplayName

Axis.Pages.DisplayName

Axis.Panels.DisplayName

Axis.Rows.DisplayName

Axis.Size.DisplayName

Axis.X.DisplayName

Axis.Y.DisplayName

InnerAxis.Color.DisplayName

InnerAxis.SectorSize.DisplayName

Axix.Identifier.DisplayName

Color by

Trellis columns

Marker by

Trellis pages

Trellis panels

Trellis rows

Marker size by

X-axis

Y-axis

Pie sector color

Pie sector size

Coloring data table identifier

Treemap

Axis.Color.DisplayName

Axis.Columns.DisplayName

Axis.Pages.DisplayName

Axis.Panels.DisplayName

Axis.Rows.DisplayName

Axis.Size.DisplayName

Axis.Hierarchy.DisplayName

Color by

Trellis columns

Trellis pages

Trellis panels

Trellis rows

Size by

Hierarchy

Heat Map

Axis.Columns.DisplayName

Axis.Pages.DisplayName

Axis.Panels.DisplayName

Axis.Rows.DisplayName

Axis.X.DisplayName

Axis.Y.DisplayName

Axis.Measures.DisplayName

Trellis columns

Trellis pages

Trellis panels

Trellis rows

X-axis

Y-axis

Cell values

Parallel Coordinate Plot

Axis.Line.DisplayName

Line by

Summary Table

Axis.CategoryAxis.DisplayName

Categorization

See also:

Working with Dynamic Titles and Descriptions

Titles and Descriptions Overview