Use Spark Charts to Examine Trends

You can add a spark chart to a tile visualization to view aggregate data trends over time.

The red dot on the spark chart line shows the lowest value, and the green dot shows the highest value. The tooltip shows the first, last, lowest, highest and average aggregate values for the selected category. Hover your cursor anywhere over the spark chart to display the tooltip.

  1. On the Home page, hover over a workbook, click Actions Actions icon, then select Open.
  2. Close Auto Insights.
  3. In the Data pane, drag a measure to the canvas.
  4. In the Data pane drag a time-based data element to Category (Chart) to add a spark chart to the tile visualization. For example, select and drag Month.
  5. If you want to add a filter, drag a data element from the Data pane to Click here or drag data to add a filter.
    For example, Year.

    The filter changes the spark line to show the trend for the filtered data.

  6. If you want to change spark chart display settings, click General in the Properties pane.
    • Click Chart to display one of the following spark charts, Line with Area, Line, Bar, or Area.
    • Click Color to assign a color to the spark chart.
    • Click Position to place the chart after or below the primary tile measure.
    • Click Width or Height to specify the size of the spark chart.
    • Click High/Low Marks to hide or show the high and low marks, displayed as a green and a red dot.
    • Click Reference Line to display or remove a reference line. Use the Average option to display a reference line showing the average trend. Use the None option to remove the reference line.
  7. Click Save.