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. You can also add thresholds to calculated rows and columns.
To make it easier to find the threshold values, you can change the font color or the cell background.
With your table selected, open Builder, choose a measure, select , and then choose one of the following options.
You can also create or change thresholds from your table. Select a measure in the table, right-click and select Thresholds, and then select either New Threshold or Edit Ranges.
Option |
Description |
---|---|
New Threshold |
Follow the steps for creating a story-defined threshold (Creating Story-Defined Thresholds). |
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. |
If the thresholds are not visible, select the measure, select
, and then select the appropriate threshold.- 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.