Skip to content

Latest commit

 

History

History
93 lines (68 loc) · 5.09 KB

visualization-areachart.md

File metadata and controls

93 lines (68 loc) · 5.09 KB
title description ms.reviewer ms.topic ms.date monikerRange
Area chart visualization
This article describes the area chart visualization.
alexans
reference
08/11/2024
microsoft-fabric || azure-data-explorer || azure-monitor || microsoft-sentinel

Area chart

[!INCLUDE applies] [!INCLUDE fabric] [!INCLUDE azure-data-explorer] [!INCLUDE monitor] [!INCLUDE sentinel]

The area chart visual shows a time-series relationship. The first column of the query should be numeric and is used as the x-axis. Other numeric columns are the y-axes. Unlike line charts, area charts also visually represent volume. Area charts are ideal for indicating the change among different datasets.

Note

This visualization can only be used in the context of the render operator.

Syntax

T | render areachart [with (propertyName = propertyValue [, ...])]

[!INCLUDE syntax-conventions-note]

Parameters

Name Type Required Description
T string ✔️ Input table name.
propertyName, propertyValue string A comma-separated list of key-value property pairs. See supported properties.

::: moniker range="microsoft-fabric || azure-data-explorer"

Supported properties

All properties are optional.

PropertyName PropertyValue
accumulate Whether the value of each measure gets added to all its predecessors. (true or false)
kind Further elaboration of the visualization kind. For more information, see kind property.
legend Whether to display a legend or not (visible or hidden).
series Comma-delimited list of columns whose combined per-record values define the series that record belongs to.
ymin The minimum value to be displayed on Y-axis.
ymax The maximum value to be displayed on Y-axis.
title The title of the visualization (of type string).
xaxis How to scale the x-axis (linear or log).
xcolumn Which column in the result is used for the x-axis.
xtitle The title of the x-axis (of type string).
yaxis How to scale the y-axis (linear or log).
ycolumns Comma-delimited list of columns that consist of the values provided per value of the x column.
ytitle The title of the y-axis (of type string).

::: moniker-end

::: moniker range="azure-monitor || microsoft-sentinel"

Supported properties

All properties are optional.

PropertyName PropertyValue
kind Further elaboration of the visualization kind. For more information, see kind property.
series Comma-delimited list of columns whose combined per-record values define the series that record belongs to.
title The title of the visualization (of type string).

::: moniker-end

kind property

This visualization can be further elaborated by providing the kind property. The supported values of this property are:

kind value Description
default Each "area" stands on its own.
unstacked Same as default.
stacked Stack "areas" to the right.
stacked100 Stack "areas" to the right and stretch each one to the same width as the others.

Example

:::moniker range="azure-data-explorer"

[!div class="nextstepaction"] Run the query ::: moniker-end

demo_series3
| render areachart

:::image type="content" source="media/visualization-areachart/area-chart.png" alt-text="Screenshot of area chart visualization." lightbox="media/visualization-areachart/area-chart.png":::