Applying Conditional Formatting

Objective

After completing this lesson, you will be able to apply conditional formatting on single or multiple table cells.

Conditional Formatting

You can apply conditional formatting by defining thresholds to account dimension members and measures either in a story or a model. For example, in your model you could define a threshold for revenue at $1,000,000, so that all stories based on the model can use the pre-defined revenue threshold of $1,000,000. When defining thresholds in a model, the definition is done only once. But thresholds at the story level must be defined in every story.

Define Thresholds in a Story

To define thresholds in a story, choose Conditional Formatting from the ...More option in the Tools area of the ribbon. From there, simply define your criteria for the formatting colors. Once the conditional formatting is defined, you can apply it to charts or tables on your story pages.

Apply to a Chart

You can apply conditional formatting to either a measure in a chart or to the Color definition for a chart in the Builder pane.

Apply to a Table

You can apply conditional formatting to a measure in a table in the Builder pane. You can also define a new threshold, just as you would from the main toolbar.

Thresholds on Single or Multiple Table Cells

If you have multiple measures/accounts displayed in a table, you can create and apply thresholds for each measure. You can also create multiple thresholds for a particular measure, but you can apply only one threshold at a time.

Example of a table with multiple thresholds applied

Apply Conditional Formatting in a Story

Task 1: Create a Threshold and Apply it to a Chart

Business Scenario

You have created a story and decide that you would like to add conditional formatting to highlight specific data. To do this, you create thresholds for the story and apply it to the chart you have created. You also create a new bullet chart that will have the same formatting applied to it.

In this practice exercise, you will:

Create a story threshold based on a number range for gross margin
Apply the threshold to a bar/column chart
Add and configure a bullet chart in your story
Apply the threshold to a bullet chart

ExerciseStart Exercise

Task 2: Use Conditional Formatting in a New Table in a Story

Business Scenario

You have created a new page in your story and want to create a table to compare net revenue with cost of goods sold. You want to apply thresholds to this table that will display as either a symbol or as color values.

In this practice exercise, you will:

Create a measure-based threshold by comparing net revenue and cost of goods sold
Apply the threshold to a table

ExerciseStart Exercise

Next lesson