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