The “Average” format conditions allow you to highlight values above or below an average value:

Icon “Ranges” allow you to use predefined or custom sets of icons to apply conditional formatting to different ranges of values: For example, let us select the 4-range highlight for the “Gross Profit” measure: The following options are available in the appeared window: Format style – the “Format Style” combo box allows you to change […]

An “Expression” format condition allows you to use complex conditions to apply formatting:

To format values according to the required condition, click the data item menu button, select “Add Format Rule”/“Color Ranges” and choose the required color set: The working principle is the same as for the “Format Rule: Icon Ranges” highlight rule:  

“Gradient Ranges” allow you to use predefined color gradients to apply conditional formatting to different ranges of values. You can also use specific colors to generate custom gradients.: The form of the gradient highlight looks the following: The following options will be available in the appeared window: Number of ranges – “Number of ranges” allows […]

The “Bar” format condition allows you to visualize numeric values using bars. You can also paint bars corresponding to positive and negative values using different colors: This dialog allows you to change the following options specific to the “Bar” format condition: Min/Max – by default, lengths of the shortest and longest bars correspond to minimum […]

“Bar Color Ranges” allow you to visualize numeric values using bars whose colors are contained in the specified color set: This dialog allows you to change the following options specific to “Bar Color Ranges”: The following options will be available in the appeared window: Format style – the “Format Style” combo box allows you to […]

This dialog allows you to change the following options specific to “Bar Gradient Ranges”: Number of ranges – “Number of ranges” allows you to specify the number of ranges used to classify Click the Generate Ranges button to generate a new gradient scale according to the specified number of ranges; Use % ranges – the […]

The “Top N” feature allows you to display only a limited number of values that correspond to the highest or lowest values of a particular measure. Let us consider the working principle of the given functionality on an example of a grid (the highlight rule – line color range): We display only 7 subcategories with […]

Let us sort the table obtained earlier in the decreasing order of the “Order Count” measure. For this, click in the right corner of the table next to an icon: The column with the “Order Count” measure is sorted in a descending order: Having clicked again, we get the opposite result (an increase of the […]