Specification

Last update: 26 February 2025

v 1.0.0.13

Purpose

To show category data in a single line display of circles arranged horizontally or vertically, with the option to sort, size by, and color by three further data series. Tooltips are provided as standard, with the ability to filter or highlight other visuals on click.

Functionality

Data

The data pane contains four data wells. Each data well can accept a maximum of one data series.

The first data well, for Category, is mandatory, even if you are using Manual Override. (Power BI standard functionality prevents the visual rendering if there is no data.) Status Bar visual expects to treat this data as text. There is a maximum of 31 categories.

The second data well, for Size By, is optional. You can apply standard Power BI aggregations to this data (e.g. Sum, Average...). If you place a numeric series in here, it will determine the radius of the circles, providing a proportional representation of your data.

The third data well, for Sort By, is optional. You can apply standard Power BI aggregations to this data (e.g. Sum, Average...). As with standard Power BI visuals, if you click the three dots (ellipses) on the Status Bar visual, you have the option to sort by Category (alphabetically) or by any of the optional numeric series, if they have been provided. You can toggle these options ascending or descending. Any data provided in this series will also automatically appear in tooltips.

However, if your data is days of the week, these options will not help you order the days in their natural order. Here you can add a data series to the Sort By data well. This data should map to the category, for example: Monday - 1, Tuesday - 2, etc. Once you provide a series, if you click the ellipses on the visual and click Sort By, you will see this additional series available for sorting and it will appear in tooltips.

The final data well, Color by Data, is optional. It won't do anything unless you switch the Color by Data toggle on in the formatting pane. An error message will direct you to switch the Color by Interpolation toggle off, since you can't have two Color By methods in place at once. Specify High, Medium, and Low values and corresponding colors, and Status Bar will interpolate between them. Further information in the formatting pane section below will tell you how to customize the colors.

Highlighting

If highlighting is selected under Edit Interactions, clicking a circle will highlight the chosen category within other visuals on the page. The Status Bar will itself be highlighted by other visuals on the page when you select an entire category. Note that inbound highlighting will only work if a numeric series is bound to the category data. Partial highlighting of the circles is unsupported.

You can use View > Edit Interactions to change the default behavior on click.

Filtering

If filtering is selected under Edit Interactions, clicking a circle will filter the chosen category within other visuals on the page. The Status Bar will itself be filtered by other visuals on the page, where you are selecting an entire category. Filtering works regardless of numeric series being provided.

You can use View > Edit Interactions to change the default behavior on click.

Hover

On hover, there is a tooltip that will show as many series as have been entered into the data pane. Note that the Color By Data number series will only show if Color By Data is selected in the formatting pane. Category will always be shown, since it is mandatory. If Manual Override is on, no tooltip will be displayed.

Resize

The Status Bar visual dynamically adjusts to changes in size and should display the full range of data provided. Circle sizes will remain proportional to their respective Size By values, and the visual will resize immediately when the visual or viewport dimensions change.