Series Properties for Measure
Check out a walk through on how to configure the Series Properties.
The users can configure and modify various measure related properties through the Series Properties window.
Navigate to the Design page for a view that has one or more selected measure values.
Click the Series Properties option provided next to a dragged measure.
A tab opens by the default name of the selected measure.
The users can set the following properties from a pop-up window for a mixed chart with two measures dragged on the workspace:
Aggregation: Select an aggregation option from the drop-down menu (the given choices are: Sum, Min, Max, Variance, Mean, Standard Deviation, Cumulative Sum)
Display Name: Enter the title for the measure to be displayed in the data label
Series Type: Choose a series type format for the selected measure
Point Shape: Select a point shape from the drop-down menu. (the given choices are: Cross, Cube, Hexagon, Point, Quad, Star, Triangle)
Line Type: Select a line type from the drop-down menu (the given choices are: Straight, Dot, Dash, Dash1)
Axis: Select an axis out of the given choices (the users need to enable the Secondary Value Axis to get the Axis option in the Series Properties window)
Color: Select the color of the chart presentation from the given menu
Data Label Color: Choose a color for the data label from the given menu
Data Label Position: Select a position to display the data label (the given choices are: Top, Middle, Bottom)
Conditional Colors: Click the Conditional Colors icon to insert a new condition.
Configure the below-given fields to apply a new condition on the selected measure.
Operator- Select an operator from the drop-down menu (the supported operations are <, <=, >, >=, ==, !=).
Compared To - Set a value to which the operator can be applied.
Color- Choose a color to be applied when the set condition is met.
Click the Save option.
The user can provide multiple conditions for a single measure column.
Please Note:
The Series Properties may differ as per the selected chart components.
Users need to enable the Secondary Value Axis from the Properties tab to get the Axis field in the Series Properties.
Users can change or modify the View title by clicking on the edit options provided next to the view name.
Click the Edit icon > Modify/change the title for the selected measure or dimension > click the Checkmark icon to save the change and the Close mark icon for not to save the change.
Last updated
