MicroStrategy ONE

How to Display a Reference Line in a Graph Visualization

A reference line, also referred to as a base line, is a user-defined vertical or horizontal line in the graph. Use reference lines to compare, reference, or measure against the data values displayed in the graph.

In a graph visualization that displays regional revenue values, you can define a reference line for your target revenue, to see at a glance how each region compares to the target.

You can display one or more reference lines in a graph visualization, using different line types. Reference lines are available if the X or Y axis contains a metric. Reference lines are not available for stacked graphs.

  1. Click on the graph visualization you want to modify.
  2. Right-click the numeric axis to use as a basis for the reference line. If the axis contains more than one metric, choose the metric name. Then, select Add Reference Line and the location of the reference line.

  3. To format a reference line, right-click it and choose Format. A pop-up menu displays the appropriate formatting options. In addition, the Format panel automatically updates the first drop-down to the Reference Lines option and the corresponding format options appear.
  4. Select the appropriate options to format the reference line.