Gallery

A table (also known as a list table) is a two-dimensional representation of data. Values are arranged in unlabeled rows and labeled columns. A table cannot use a hierarchy.

A crosstab (also known as a crosstabulation table) shows an aggregate metric for the intersections of two or more categories. In a crosstab, categories are typically displayed in both the columns and the rows. Each cell value represents the aggregated measure from the intersection of the categories in the cell’s row and column. A crosstab uses less space than a traditional table and is easier to read because data is grouped both horizontally and vertically. A crosstab can use a hierarchy. Frequency is displayed when there are no measures in the crosstab.

A bar chart consists of vertical or horizontal bars that represent quantitative data. Use bar charts to compare data that is aggregated by the distinct values of a category.

A line chart shows the relationship of one variable to another, often as movements or trends in the data over a period of time. Line charts summarize source data, and typically are used to show how values change over time. You can apply grouping and create lattices.

A scatter plot is a two-dimensional plot that shows the joint variation of two data items. Each marker (represented by symbols such as dots, squares, or plus signs) represents an observation. The marker position indicates the value for each observation. Use a scatter plot to examine the relationship between numeric data items. You can apply grouping. (In the designer, grouping is called "color.")

A bubble plot displays the relationships among at least three measures. Two measures are represented by the plot axes, and the third measure is represented by the size of the plot markers. Each bubble represents an observation. A bubble plot is useful for data sets with dozens to hundreds of values. You can apply grouping and create lattices. You can use color to represent an additional measure and animate the bubbles to display changes in the data over time.

A geo bubble map is a bubble plot that is overlaid on a geographic map. Each bubble is located at a geographic location or at the center of a geographical region. A geo bubble map requires a data item that contains geographical information and is assigned to a geography role.

A geo coordinate map is a simple scatter plot that is overlaid on a geographic map. Each point is located at a geographic location or at the center of a geographical region. A geo coordinate map requires a data item that contains geographical information and is assigned to a geography role.

A geo region map (also known as a choropleth map) is a two-dimensional map that uses colors to represent different categories or levels of magnitude. You can fill geographical boundaries (for example, a country or a state) on a map with color, based on measure values that are aggregated to the level defined by a geographical boundary. A geo region map requires a data item that contains geographical information and is assigned to a geography role.

A histogram displays the distribution of values for a single measure.

A box plot displays the distribution of values for a single measure using a box and whiskers. The size and location of the box indicate the range of values that are between the 25th and 75th percentile. Additional statistical information is represented by other visual features.

A heat map displays the distribution of values for two data items using a grid of colored cells. If you do not assign a measure to the color data role, then a cell’s color represents the frequency of each intersection of values. If you assign a measure to the color data role, then a cell’s color represents the measure value of each intersection of values.

A treemap displays your data as a set of rectangles (called tiles). Each tile represents a category or a hierarchy node. The color of each tile represents the value of the first measure. The size of each tile represents the value of the second measure. For example, a sales data treemap might have tile sizes that represent the number of orders and tile colors that are derived from color gradients that represent sales.

A correlation matrix displays the degree of correlation between measures as a series of colored rectangles. The color of each rectangle indicates the strength of the correlation.

A decision tree displays a series of nodes as a tree, where the top node is the target data item and each branch represents a split in the values of a predictor data item. A split enables you to see which value of the predictor data item corresponds to a different distribution of the value in the target data item.

A network diagram displays a series of linked nodes. A network diagram displays the relationships between the values of categories or hierarchy levels. You can indicate the values of measures through the sizes and colors of the nodes and the node links.

A Sankey diagram displays a series of linked nodes, where the width of each link indicates the frequency of the link or the value of a measure.

A word cloud displays a set of category values as text, grouped in a cloud-like shape. Depending on the type of word cloud and your data roles, the size of each word in the cloud can indicate the relevance of the word to a topic, the frequency of the word in a category, or the value of a measure. In the explorer, you can use text analytics in a word cloud to identify topics and terms that appear together in your data and to analyze the sentiment of the documents in a topic.

A targeted bar chart is a bar chart that has pointers to target values. In this example, the pointers appear above each bar.

A waterfall chart (also known as a progressive bar chart) shows how the initial value of a measure increases or decreases during a series of operations or transactions. The first bar begins at the initial value, and each subsequent bar begins where the previous bar ends. The length and direction of a bar indicate the magnitude and type (positive or negative, for example) of the operation or transaction. The resulting chart is a stepped cascade that shows how the operations or transactions lead to the final value of the measure.

A pie chart is a circular chart that is divided into slices by radial lines. Each slice represents the relative contribution of each part to the whole.

A time series plot shows an ordered sequence of values that are observed at equally spaced time intervals. A time series plot requires a date or date time category data item that is continuous.

A dual axis bar chart is a variation of the bar chart that has two measures. A measure is on each axis.

A dual axis line chart is a variation of the line chart that has two measures. A measure is on each axis.

A dual axis bar-line chart is a variation of the bar chart that has two measures. A measure is on each axis, and the bar chart is overlaid by a line chart.

A dual axis time series plot is a variation of the time series plot that has two measures. A measure is on each axis.

A bullet gauge is a dashboard indicator (also known as a key performance indicator (KPI) chart) that compares an actual value to a target value in intervals. The actual value is indicated by an inset bar.

A slider gauge is a dashboard indicator (also known as a KPI chart) that compares an actual value to a target value in intervals. The actual value is indicated by an arrow.

A thermometer gauge is a dashboard indicator (also known as a KPI chart) that compares an actual value to a target value in intervals. The actual value is indicated by a bar.

A dial gauge is an arc-shaped dashboard indicator (also known as a KPI chart) that compares an actual value to a target value and compares them in intervals. The actual value is indicated by an arrow that points outward from the inner circle.

A speedometer gauge is a circular dashboard indicator (also known as a KPI chart) that compares an actual value to a target value and compares them in intervals. The actual value is indicated by the larger pointer.