Formatting

<< Click to Display Table of Contents >>

Navigation:  Dashboard Designer > Dashboard Item  > Cards >

Formatting

 

Formatting

The Card dashboard item formats the actual and target values displayed within cards using format settings specified for data items. Click the options buttons (the DCardFormat1 icon) displayed next to the data item container in the Cards section to change format settings for other values.

DCardFormat2

In the invoked Card Settings dialog, go to the Format Options tab and use the Select value type option to specify which values’ format settings should change.

DCardFormat3

You can change format settings for the following value types:

Actual Value

Target Value

Absolute Variation

Percent of Target

Percent Variation

To learn more about format settings, see Formatting Numeric Values in the Formatting Data topic.

Conditional Formatting

For a Card dashboard item, you can apply conditional formatting to the card's visual elements (e.g., Title, Subtitle, various values) and change the card's background.

 

DCardFormat4

 

Supported Format Rules

You can use measure or dimension values to calculate a format rule. You can also use delta values to calculate a Card dashboard item's format rules.

The following list contains available format rules and corresponding data types:

numeric

Value

Top-Bottom

Average

Expression

Icon Ranges

Color Ranges

Gradient Ranges

Value (with a condition type set to Equal To, Not Equal To or Text that Contains) Expression

date-time

Value

A Date Occurring (for dimensions with a continuous date-time group interval) Expression

Icon Ranges

Color Ranges

Gradient Ranges

Create a Format Rule

You can create format rules in the following ways:

 

DCardFormat6

The invoked dialog contains the calculated by combo box, where you can select the item whose values are used to calculate the format rule.

DCardFormat8 To apply a format rule to a specific card, use delta values to calculate the rule. The expression format condition is an exception to this rule and applies to all cards.

To apply a format rule to all cards in a Card item, use hidden measures and series dimensions to calculate the rule.

For a Card item, the Edit Rules dialog has a using combo box. If you use a delta calculation, specify the delta type in this box. Click the Add button, select the format rule from the pop-up menu, and specify the rule's condition:

DCardFormat9

click the series dimension/hidden measure menu button.

DCardFormat10

Refer to the following topic for information on how to create and edit format rules: Conditional Formatting Common.

Card-Specific Format Condition Settings

Specify appearance settings and set the condition's value for the format rule. Available settings depend on the selected format rule.

The appearance settings dialog contains the Apply to drop-down list. Select a layout element to which you want to apply a format rule. Select All elements to apply the format rule to all card elements.

The image below displays the Greater Than dialog that corresponds to the Value format condition.

DCardFormat11

The background color applies to the entire card. Note that the Apply to drop-down list is not in effect.

DCardFormat12

Some predefined background styles contain a font color. This font color applies to all card elements regardless of drop-down list settings (for any card layout element).

Edit a Format Rule

To edit format rules for the current Card dashboard item, use the following options.

Click the Edit Rules button in the Home ribbon tab or use a corresponding item in the Card context menu. Click the menu button for the required data item and select Edit Rules.

All of these actions invoke the Edit Rules dialog that contains existing format rules. For more information, see Conditional Formatting.