Adding a data label

Contents[Hide]

1. Overview

A data label is a data-driven text label which you can add to your dashboard, report, or scorecard in order to display a measure or hierarchy value. A data label is also the default data visualization type that is used when you drag a column to a report or scorecard region.

2. Displaying a measure value

As an example, create a new dashboard based on the Blank template.

Go to the toolbar, click Data Visualization, and then click Data Label.

Add a data label from the toolbar
Add a data label from the toolbar

From the Explore window, drag a measure column from a data connector or data cube and drop it onto the empty data label.

Drag a measure column to the data label
Drag a measure column to the data label

To show a dollar sign in front of the measure value, right click on the data label and select Data Binding Panel.

Edit the LineTotal measure and type '$' in the Symbol field.

Set the Symbol field
Set the Symbol field

Click Submit and switch to View mode to see the data label. Hover over the text to see its tooltip.

View the data label
View the data label

Texts that do  not fit in the data label are truncated using an ellipsis (...).

Truncated text
Truncated text

3. Displaying a hierarchy value

While designing a report or scorecard, drag a hierarchy or dimension column from the Explore window to the report or scorecard body region. By default, the column will appear as a data label.

Using a data label to display Product hierarchy values in a report
Using a data label to display Product hierarchy values in a report

4. Properties

4.1. Text and Tooltip

Customize the text appearing in a data label and its tooltip by using the Text and Tooltip properties. You can insert regular text or use keywords in square brackets which act as placeholders (e.g., the name of a measure column).

Text and Tooltip properties for a data label
Text and Tooltip properties for a data label

4.2. Padding

Click Layout and expand the Padding property. This property is useful for lining up data labels and static labels (which also have this property) in the repeating body of a scorecard or report.

Padding property for a data label
Padding property for a data label

4.3. Highlight Measure Value Changes

When a measure displayed by a data label changes value (e.g., at the data source), the data label can be animated with a highlight color for a brief duration. This can help bring the data change to the attention of the user.

To use this feature, open the Data Binding Panel for the data label and click Edit. Make sure the Bypass Data Cache option is checked so that the latest data is used.

Go to Properties for the data label and set a value for the Data Auto Refresh Interval (seconds) property, such as 10 seconds.

Then go to the Look section and scroll down to find the Highlight Measure Value Changes property. Enable it and optionally change the highlight color or duration of the animation (i.e., duration for the highlight color to appear and then fade away in milliseconds).

Highlight Measure Value Changes property
Highlight Measure Value Changes property

Switch to View mode and effect a change in the data to see the animation. The data label will be highlighted in color which then fades away after the specified duration.

Data label is highlighted after a change in measure value is detected
Data label is highlighted after a change in measure value is detected

4.4. State Styles

Go to Look Properties to edit or add a state style for a data label.

Use these properties to set the background or border appearance for the data label under this state.

State style properties for a data label
State style properties for a data label

4.5. Allow HTML Formatting

The following feature is available in Dundas BI 2.6 or later.

By default, if your data (e.g. hierarchy value) contains HTML tags such as <b> or <i>, these will be displayed as just tags in the data label. They will not be interpreted as HTML elements. 

If you want the HTML tags to be rendered as HTML by the browser, go to Properties for your data label and enable the Allow HTML Formatting option.

As an example, suppose you have some Excel data containing a measure and hierarchy value that uses HTML (and CSS) tags.

Excel data containing HTML tags
Excel data containing HTML tags

Add this data to a blank data label and you'll see that the HTML tags are displayed unchanged by default.

Data label displays HTML tags
Data label displays HTML tags

Go to Properties for your data label and enable the Allow HTML Formatting option.

Allow HTML Formatting property
Allow HTML Formatting property

If your data contains XML tags, note that these will not be rendered because browsers ignore tags they don't understand. If you want the <xml> tag to be rendered, for example, you will need to encode it in your data as: &lt;xml&gt;

4.6. State Styles

Go to Look Properties to edit or add a state style for a data label.

Use these properties to set the background or border appearance for the data label under this state.

State style properties for a data label
State style properties for a data label

4.7. Data Brushing

Go to Look Properties to edit or add background and font color. These properties will be applied when a user hovers over the data label during view mode.

Hover over background and color properties
Hover over background and color properties

View and hover over the data label
View and hover over the data label

5. See also

 

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri