Add and modify a query visualization in the web UI
In this article, you'll learn how to create and customize visuals from query results, using the UI like that found in Azure Data Explorer Dashboards. These visuals can be further manipulated, and can be pinned in a dashboard. The addition or modification of these visuals doesn't require rerunning the query, which can be especially useful for heavy queries.
For a full list of available visuals, see Visualization. For visuals that are only available in the web UI or dashboards, see Dashboard-specific visuals.
Prerequisites
- A Microsoft account or a Microsoft Entra user identity. An Azure subscription isn't required.
- An Azure Data Explorer cluster and database. Use the publicly available help cluster or create a cluster and database.
Add a visual to a query
Run a query in the Azure Data Explorer web UI. For example, you can use the following query:
StormEvents | where State == 'KANSAS' | summarize sum(DamageProperty) by EventTypeIn the results grid, select + Add visual.
A pane opens on the right side, with the Visual Formatting tab selected.
Select the Visual type from the dropdown. For a list of available visualizations, see Visualizations.
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 |
Change an existing visualization
There are two ways to use the visual formatting pane to change an existing visualization.
Visual created with UI
If you've added a visual through the UI, you can change this visual by selecting the Edit visual tab in the results grid.
Visual created in query
If you've created a visual using the render operator, you can edit the visual by selecting Visual in the results grid.
Important
Notice that the visual formatting pane has changed the visual representation, but has not modified the original query.
Pin to dashboard
After you have formatted your visual, you can pin this visual to a new or existing dashboard.
From the visual formatting pane, select Pin to dashboard.
The pin to dashboard dialog opens. Enter a Tile name for this visual and select a new or existing dashboard.
Select Pin.