Using Thresholds in Tables
Add thresholds to tables and choose how to display the threshold values.
You can add thresholds to measures in tables, including calculated and restricted measures.
After the threshold is applied to the table, when you move the cursor over a value, the tooltip will display the range and threshold name.
You can also add thresholds to calculated rows and columns, however those thresholds use number ranges only; they cannot be compared to measure values.
For information on how to create a threshold, see Creating Story-Defined Thresholds (Optimized Story Experience).
Add a Threshold to a Table
You can add thresholds to the table directly or by using the builder panel.
-
Create a new threshold.
Use Table Cells Use the Builder Panel -
Select one or more table cells.
-
Right-click and then select New Threshold.
-
With your table selected, open the Builder panel.
-
Choose a measure or account.
-
Select
(More) 
Thresholds New Threshold
.The Thresholds panel appears.
-
In the Model section, select a model and a measure.
-
-
In the Thresholds section, provide the necessary details.
-
When you're finished, click Apply.
To make it easier to find the threshold values in the table, you can change the font color or the cell background.
Use or Modify Existing Thresholds
Once you've created some thresholds, you may want to edit the ranges, or see a list of available thresholds.
With your table selected, open Builder, choose a measure, select (More) Thresholds, and then select one of the following options.
|
Option |
Description |
|---|---|
|
New Threshold |
Follow the steps for creating a story-defined threshold (Creating Story-Defined Thresholds (Optimized Story Experience)). |
|
Show Thresholds |
Shows all the valid assigned threshold values in the table cells. |
|
Edit Ranges |
Allows you to edit the threshold ranges for the selected threshold. |
|
View All Thresholds |
Opens the Conditional Formatting panel to display all thresholds. |
Changing How Threshold Values Are Displayed
- Select the table tile.
- In the Styling panel, find the Templates section.
- In the Threshold Style list, choose the style:
- Symbol (default) – use the story-defined symbols and colors for the threshold ranges.
- Color Values – the threshold colors are applied to the cell data.
- Color Background – the threshold colors are applied to the cell background.
- Color Background Without Values – the threshold colors are applied to the cell background and the values are hidden.
The table cells automatically change to reflect the new style choice.