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. For example, you may want the color axis to automatically update to the same expression as what is used on a categorical 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}, ${Axis.Axis Name.ShortDisplayName} and ${Axis.Axis Name.Expression}, for the display name, short display name and the underlying expression, respectively. For example, if the Axis Name is "X", the expression could refer to ${Axis.X.DisplayName}, ${Axis.X.ShortDisplayName}, 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 Axis.Measures Axis.Rows |
Horizontal axis Cell values Vertical axis |
Graphical table |
Axis.Rows |
Graphical table rows |
Bar chart |
Axis.Color Axis.Columns Axis.Pages Axis.Panels Axis.Rows Axis.X Axis.Y |
Color by Trellis columns Trellis pages Trellis panels Trellis rows Category axis Value axis |
Waterfall chart |
Axis.Color Axis.Columns Axis.Pages Axis.Panels Axis.Rows Axis.X Axis.Y |
Color by Trellis columns Trellis pages Trellis panels Trellis rows Category axis Value axis |
Line chart |
Axis.Line Axis.Color Axis.Columns Axis.Pages Axis.Panels Axis.Rows Axis.X Axis.Y |
Line by Color by Trellis columns Trellis pages Trellis panels Trellis rows X-axis Y-axis |
Combination chart |
Axis.Color Axis.Columns Axis.Pages Axis.Panels Axis.Rows Axis.X Axis.Y |
Color by Trellis columns Trellis pages Trellis panels Trellis rows X-axis Y-axis |
Pie chart |
Axis.Color Axis.Columns Axis.Pages Axis.Panels Axis.Rows Axis.Size InnerAxis.Color InnerAxis.SectorSize |
Color by Trellis columns Trellis pages Trellis panels Trellis rows Pie size by Color by Sector size by |
Scatter plot |
Axis.Color Axis.Columns Axis.DrawingOrder Axis.Line Axis.Marker Axis.Order Axis.Pages Axis.Panels Axis.Rotation Axis.Rows Axis.Shape Axis.Size Axis.X Axis.Y InnerAxis.Color InnerAxis.SectorSize |
Color by Trellis columns Drawing order by Connect by (Draw a separate line per value in) Marker by Order by (Order each line by) Trellis pages Trellis panels Rotation by Trellis rows Shape by Size by X-axis Y-axis Pie sector color Pie sector size |
3D scatter plot |
Axis.Color. Axis.Columns. Axis.Marker. Axis.Pages Axis.Panels Axis.Rows Axis.Size Axis.X Axis.Y Axix.Z |
Color by Trellis columns Marker by Trellis pages Trellis panels Trellis rows Marker size by X-axis Y-axis Z-axis |
Map chart – Feature layer |
Axis.Color Axis.Columns Axis.Geometry Axis.Pages Axis.Panels Axis.Rows |
Color by Trellis columns Feature by Trellis pages Trellis panels Trellis rows |
Map chart - Marker layer |
Axis.Color Axis.Columns Axis.DrawingOrder Axis.Line Axis.Marker Axis.Order Axis.Pages Axis.Panels Axis.Rotation Axis.Rows Axis.Shape Axis.Size Axis.X Axis.Y InnerAxis.Color InnerAxis.SectorSize |
Color by Trellis columns Drawing order by Connect by (Draw a separate line per value in) Marker by Order by (Order each line by) Trellis pages Trellis panels Trellis rows Rotation by Shape by Marker size by X-axis Y-axis Pie sector color Pie sector size |
Treemap |
Axis.Color Axis.Columns Axis.Pages Axis.Panels Axis.Rows Axis.Size Axis.Hierarchy |
Color by Trellis columns Trellis pages Trellis panels Trellis rows Size by Hierarchy |
Heat map |
Axis.Columns Axis.Pages Axis.Panels Axis.Rows Axis.X Axis.Y Axis.Measures |
Trellis columns Trellis pages Trellis panels Trellis rows X-axis Y-axis Cell values |
KPI chart |
Axis.Color Axis.Comparative Axis.Tile Axis.X Axis.Y |
Color by Comparative value Tile by X-axis Y-axis |
Parallel coordinate plot |
Axis.Line |
Line by |
Summary table |
Axis.CategoryAxis |
Categorization |
Box plot |
Axis.Color Axis.Columns Axis.Pages Axis.Panels Axis.Rows Axis.X Axis.Y |
Color by Trellis columns Trellis pages Trellis panels Trellis rows X-axis Y-axis |