Last Modified Date: 13 Mar 2017
AnswerThis article expands on the steps for creating key progress indicators, adding information for formatting the cell background color based on the indicator value.
Step 1: Create a KPI
Create a KPI view using the steps provided in Creating Key Progress Indicators (KPIs).
You can also download the attached sample workbook to see the finished result.
Step 2: Set up conditional background color
- Drag the KPI field to Color on the Marks card.
- Change the mark type to Bar.
- (Optional) Click the arrow in the upper-right corner of the Color legend, select Edit Colors, and select the color palette you want.
- Drag Number of Records to Size on the Marks card.
- Click the arrow in the upper-right corner of SUM(Number of Records), select Measure (Sum) > Minimum
- Adjust mark size as desired. See Size Properties for more information.
- (Optional) Hide the Number of Record Card.
Additional InformationThis article expands on the steps for creating key progress indicators, adding information for formatting the cell background color based on the indicator value.
Note: To color the background of the dimensions located in the Rows, see the workaround described in the following Community thread: How to display the range for measure and highlight the dimensions.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials