The Top-Bottom format conditions allow you to highlight a specific number of topmost/bottommost values. You can specify this number as an absolute or percent value.
The following condition types are supported for measures.
Can be applied to
The Top N format condition allows you to apply formatting to elements whose values are ranked at the top. For instance, the following image displays a Grid dashboard item whose top 3 Extended Price values filled in green.
The Bottom N format condition allows you to apply formatting to elements whose values are ranked at the bottom. For instance, the following image displays a Grid dashboard item whose bottom 40 percent Extended Price values are filled in red.
Click the measure's menu button and select Add Format Rule | Top/Bottom and choose the required type:
This action invokes the dialog that allows you to configure a format rule and specify its style:
Here you can specify the number of top or bottom values to be displayed and whether to use a number or a percent to calculate top / bottom values.
In the Conditional Formatting section, click the plus button to add a new format rule:
Select the data item you want to format and set the condition type to Top/Bottom:
Select the required format rule's type:
This action opens the Top/Bottom settings where you can configure a format rule and specify its style:
To create the Top-Bottom format condition in code, create the FormatConditionTopBottom class instance and specify the following settings.