> For the complete documentation index, see [llms.txt](https://docs.inforiver.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.inforiver.com/~/changes/mS6jwvARNLHpKqBa4cT9/working-with-inforiver/6.-working-with-charts/sparkline-charts.md). # Sparkline charts A sparkline is typically used to show trends in a series of values over time, such as stock prices or website traffic. Sparklines are often used in dashboards and other data visualizations to provide a quick and condensed view of a data series. Inforiver provides *line, area, baseline, column*s, and *win-loss* sparkline charts. ## 1. Adding the chart In this example, we have 12 months of data across regions and categories and we want to visualize using a column sparkline chart. a) To insert a sparkline chart, you need to add a time dimension in the column field. Note that we have added 'Month' in the 'Columns' field in the Visualization pane.

b) Select a column for which you want to insert the sparkline chart. In the following image, the 2022 Actuals for the month Jan has been selected. The sparkline chart option gets enabled. From the 'Sparkline chart' drop-down, select the 'Column sparkline chart'.

c) The spark column appears incorporating data for all the months. You can see the *minimum* and *maximum* values for each row in *red* and *green*. You can see the 'Customize' tab in the toolbar and the following [customization options](#2.-customization-options).

{% hint style="info" %} You can select a **subset of the columns** using Shift/Ctrl + Click if you do not want to visualize all the periods as a sparkline. {% endhint %} ## 2. Customization options The following options are available for customizing a sparkline chart. {% hint style="info" %} Depending on the type of sparkline chart chosen, some of these options may or may not be available. {% endhint %} ### **i) Sparkline** You can change your current sparkline chart type by clicking on the drop-down arrow in the 'Sparkline' section. In the image below, we have changed the chart type from '*Column sparkline*' to '*Baseline*'.

### **ii) Marker** From the 'Marker' drop-down, you can select the type of marker points you want to insert in your chart. Adding marker points in your chart helps you to analyze and understand the data better. You can insert marker for: * **All points** - All the points in the chart * **None** - No points at all * **Min, Max, First, Last** - Only for the minimum, maximum, first, and last values in the chart * **Min, Max** - Only for the minimum and maximum values * **First, Last** - Only for the first and last values * **Max** - Only for the maximum value * **Last** - Only for the last value

### **iii) Scale bands** 'Scale bands' visually display information about the overall distribution of values. If the distribution of values falls in the *first quartile (0-25%)*, then it is represented by a *lighter shade of gray*. However, if the value distribution falls in the *last quartile (75-100%)*, then it is represented by a *darker shade of gray*. {% hint style="info" %} The scale bands option is available only if you select any of the standard sparkline chart types (*Line Linear, Line Spline,* or *Line Stepped*). {% endhint %}

### **iv) Show column** From the 'Show column' section, you can choose whether to show the *Min, Max, Avg,* or *Sum* columns or *All children (enabled by default).* In the below image, the *Avg* and *Min* columns are enabled in the Show Column option, and the report shows the Min and Average columns.

### **v) Axis config** You can configure the *type* and *style* of the axis line from the 'Axis config' option. Clicking on the 'Axis Config' option will open up the Axis config modal, in which you can choose the type and style of the axis. {% hint style="info" %} The axis config option is available only for the *baseline* chart. {% endhint %}

**Type** - An axis in a chart basically serves as a reference making it easy to interpret other data values with respect to it. Depending on the axis type you choose, the axis will get displayed at the * **Median** - Median value of the data set * **Average** - Average value of the data set * **Mid value** - Mid value of the data set * **Standard deviation** - Standard deviation of the data set * **Custom** - When the custom option is chosen, you can define a custom value for the axis as shown below.

**Style** - This option lets you configure how the axis line of the chart should look like. You can select any of the following styles for the axis line - *Solid, Dotted, Dashed, Long dashed* and *Double solid.* ### **vi) Null display** Using the 'Null display' option, you can configure how you want to connect the null values in your dataset. In this example, the 2023 Budget for Feb and May are blank. * **Connect over nulls** - If you select this option, then all the null data points in the dataset will be connected over by lines.

* **Consider null as 0** - All the null values in the dataset will be considered '*0' (Zero)*

* **Skip the nulls** - All the null values will be skipped ### **vii) Padding** Using the 'Padding' option, you can change the padding/spacing between the bars. The default padding value is 5. {% hint style="info" %} The padding option is available only for the *Column* and *Win/Loss* Sparklines. {% endhint %}

### viii) Appearance This option lets you change the appearance of the sparkline charts. Clicking on this option will open up an 'Appearance' model in which you can configure the following properties:

**a) Apply default theme** - Enabling this option will apply default power BI themes and colors to your sparkline charts

**b) Stroke width** - With this option, you can configure the width of the stroke of your sparkline charts. The default is 1.

**c) Base color** - Using this option you can configure the base color of the strokes of the sparkline charts **d) Max** - This option lets you set the color of the maximum point in the chart **e) Min** - This option lets you configure the color of the minimum point in the chart **f) Label** - This option lets you configure the color of the data label in the chart **g) Apply gradient** - With this option, you can enable or disable the gradient coloring. If you enable this option, two additional options become available. The 'Area above 1' and 'Area above 2' using which you can set the starting and ending colors for the area above the axis.

**h) Line above** - With this option, you can set the color of the line above the axis **i) Line below** - With this option, you can set the color of the line below the axis **j) Area above** - With this option you can customize the color of the area above the axis **k) Area below** - With this option you can customize the color of the area below the axis

**l) Axis color** - This option lets you customize the color of the axis line **m) Positive color** - Using this option you can customize the positive color of the bar **n) Negative color** - Using this option you can customize the negative color of the bar

### viii) Show label You can configure whether to show or hide data labels using this option. Data labels are shown by default. Clicking on this option once will hide the data labels and clicking again will show the labels.

### **ix) Remove sparkline** Clicking on the 'Remove sparkline' option removes the sparkline chart from the report and restores it to the original number format.

In this section, we covered the sparkline charts. Navigate to the next section to learn more about [stacked charts](/~/changes/mS6jwvARNLHpKqBa4cT9/working-with-inforiver/6.-working-with-charts/stacked-charts.md). --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://docs.inforiver.com/~/changes/mS6jwvARNLHpKqBa4cT9/working-with-inforiver/6.-working-with-charts/sparkline-charts.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.