How-to
How to show change and values on a Hubviz Studio chart
Compare each point of a chart with the previous period or the same period last year, and write the values on top of columns and lines.
Two editor options help readers understand the chart without hovering over every point: Compare points with shows how much each point went up or down, and Show fixed values on the chart writes the value on top of each column or point.
When to use it
- Comparison with the previous period: to follow the pace month by month, such as “profit grew 9% in July”.
- Comparison with the previous year: for seasonal businesses, where December always sells more than November. Comparing December with last December is fairer.
- Fixed values: for printed dashboards, presentations or TV screens, where nobody hovers.
Turn on comparison and fixed values
-
Open the chart in the editor. Under Charts, click its name.
-
Under Design, open the Compare points with list and choose Previous period or Previous year (same position).
-
Hover over a point in the preview. The tooltip shows the value, the percentage change with an arrow and the difference in value.
-
To write the values on the chart, turn on Show fixed values on the chart.
-
Save with Ctrl + S.
Options
| Option | What it does | Default |
|---|---|---|
| Compare points with: None | No comparison. The tooltip shows only the value. | Yes |
| Compare points with: Previous period | Compares each point with the previous point on the same axis. February with January, March with February. | |
| Compare points with: Previous year (same position) | Compares each point with the same period of the previous year. The change gets the YoY suffix. | |
| Show fixed values on the chart | Writes the formatted value on each column, point or slice. | Off |
How to read the change
- The green up arrow is a rise; the red down arrow is a drop; the grey square is no change.
- The percentage is (point value minus reference value) divided by the reference value.
- In parentheses, Change shows the difference in the series format, such as R$ 150,710.00.
- When the reference value is zero, there is no percentage: you see N/A (base was zero).
- The first point has no previous period on the chart, so it shows no change with Previous period.
Example: July gross profit
In the Gross profit trend chart of the sample project, with Previous period:
- June 2026: R$ 1,670,802.00.
- July 2026: R$ 1,821,512.00.
- The July tooltip shows a 9.02% rise, with a change of R$ 150,710.00.
With Previous year (same position), July 2026 would be compared with July 2025. If the cube has no 2025 data, there is no reference and no change shows up.
Watch out
- The previous year ignores filters. To find last year’s value, Hubviz Studio uses the cube data without the report filters. If the dashboard is filtered to one business unit, last year’s reference may add up all units.
- Previous year needs dates on the axis. With Use categories as axis on, there is no comparison with the previous year.
- Many points, many labels. With several series and 12 months, fixed values overlap. Use them on charts with one or two series, or show fewer periods.
- The gauge always shows the value. On a Gauge, the value is highlighted with or without the option, and comparison does not apply.
- Cards have their own comparison. On a Card Chart, comparison is set in each series, under Card Comparison. See Cards and text.
- Do not confuse it with the Hubviz Web comparison. In Hubviz Web, readers can compare the whole period with another period in the calendar. See Period and comparison.