Customize Azure Data Explorer dashboard visuals

Azure Data Explorer dashboards are a collection of tiles that feature a visual representation supported by an underlying Kusto Query Language (KQL) query. This article explains how to edit the visualizations and queries of a dashboard tile and provides an overview of customization properties specific to each visualization type.

All visualizations that are created in the context of the render operator are available in dashboard visualizations, along with some dashboard-specific visuals.

Prerequisites

• Visualize data with Azure Data Explorer dashboards
• Editor permissions on an Azure Data Explorer dashboard

Customize visuals

To make changes in your dashboard:

1. In the top menu, select Viewing and toggle to Editing mode.

   

2. On the tile that you'd like to customize, select the Edit icon. Edit the underlying query or the visualization properties.

   

3. To save your changes and return to the dashboard, select Apply changes.

   

Set customization properties

The following table describes the available customization properties, categorized alphabetically by section, and specifies which visuals support the given property.

Section	Property	Description	Visual types
Colors	Color palette	Determines the set of colors to use for the heatmap.	Heatmap
Conditional formatting	Hide or Show	A toggle option to turn off or turn on conditional formatting. For more information, see Apply conditional formatting.	Anomaly chart, Area chart, Bar chart, Column chart, Multi Stat, Scatter chart, Table, Time chart
Data	Y columns	The columns that provide data for the vertical axis.	Anomaly chart, Area chart, Bar chart, Column chart, Line chart, Scatter chart, Time chart
	X column	The column that provides data for the horizontal axis.	Anomaly chart, Area chart, Bar chart, Column chart, Line chart, Scatter chart, Time chart
	Series columns	The columns used to categorize data into different series.	Anomaly chart, Area chart, Bar chart, Column chart, Line chart, Scatter chart, Time chart
	Category column	The column that determines the data categories.	Funnel chart, Heatmap, Pie chart
	Label column	Assigns labels to each slot using the designated column.	Multi Stat
	Value column	The column that provides data for the visualization.	Funnel chart, Multi stat
	Value	The numeric column that serves as the primary variable for the heatmap.	Heatmap
	Numeric column	The column that provides the numeric value for the data category.	Pie chart
	Define location by	Determines the method used to define the location: Infer, Latitude and longitude, or Geo point.	Map
Display options	Order by	How to order the results in the chart: Name, Size, or None.	Pie chart
	Top N	Option to only show sections for the top n values in the chart.	Pie chart
General	Display orientation	Determines the orientation of the display: Horizontal or Vertical.	Multi Stat
	Text size	Determines the size of the text: Recommended, Small, or Large.	Multi Stat, Stat
	Visual format	Determines the format for the chart. For area, bar, and column charts, the format can be standard, stacked, or stacked 100%. For pie charts, the format can be pie or donut.	Area chart, Bar chart, Column chart, Pie chart
Layout	Slot configuration	Customizes the grid layout with options ranging from 1 column by 1 row (1 slot) to 5 columns by 5 rows (25 slots).	Multi Stat
Legend	Hide or Show	Hides or shows a legend explaining data series in the chart.	Anomaly chart, Area chart, Bar chart, Column chart, Multi Stat, Scatter chart, Time chart
Size	Hide or Show	Toggles sizing for the map points on or off.	Map
	Size column	The column used to determine the size of the map point.	Map
URLs	Apply link on column	When enabled, selecting a value in this column directs to the URL specified in the URL column.	Table
	URL column	The column that contains URL values.	Table
X Axis	Label	Sets a custom label for the horizontal axis.	Anomaly chart, Area chart, Bar chart, Column chart, Multi Stat, Scatter chart, Time chart
	Vertical line value	Specifies a value on the horizontal axis for vertical reference lines.	Anomaly chart, Area chart, Bar chart, Column chart, Multi Stat, Scatter chart, Time chart
	X axis scale	Adjusts the scale of the horizontal axis to linear or logarithmic.	Anomaly chart, Area chart, Bar chart, Multi Stat, Scatter chart, Table, Time chart
Y Axis	Label	Sets a custom label for the vertical axis.	Anomaly chart, Area chart, Bar chart, Column chart, Multi Stat, Scatter chart, Time chart
	Maximum value	Defines the maximum value on the vertical axis.	Anomaly chart, Area chart, Bar chart, Column chart, Multi Stat, Scatter chart, Time chart
	Minimum value	Defines the minimum value on the vertical axis.	Anomaly chart, Area chart, Bar chart, Column chart, Multi Stat, Scatter chart, Time chart
	Reference lines	Marks a value on the chart as a reference line for visual guidance.	Anomaly chart, Area chart, Bar chart, Column chart, Multi Stat, Scatter chart, Time chart

Embed images

You can embed images in your dashboard tiles using Markdown text.

For more information on GitHub Flavored Markdown, see GitHub Flavored Markdown Spec.

1. Open a dashboard.

2. In the top menu, select +Add > Add text to open a text tile.

   

3. In the query pane, paste the URL of an image located in an image hosting service using the following syntax:

   ![](URL)
   

   The image renders in the tile's preview.

   

4. In the top menu, select Apply changes to save the tile.

For more information on image syntax in GitHub Flavored Markdown, see Images.

Related content

• Use parameters in Azure Data Explorer dashboards
• Write Kusto Query Language queries in the web UI