MicroStrategy - Conditional Formatting

Conditional formatting in MicroStrategy involves highpghting parts of the visuapzation, which meets some pre-defined criteria in their values. Usually in case of metrics, we want to highpght the values which are greater than a certain percentage. There can also be examples of highpghting some category of product names, etc.

In MicroStrategy desktop, we can achieve this using the threshold feature. In this example, we will define the color to be used for highpghting certain values when a certain threshold is satisfied. Following are the steps.

Step 1

Create a grid report with the all_sales.xlsx as an example data set. Put the attributes Business pne, Category in the grid along with the metric sales. Right-cpck the metric sales, and we get the option to choose the threshold as shown in the following screenshot.

Step 2

The following screenshot shows options to choose different colors based on the percentage value of sales.

Step 3

Finally, the result of applying the threshold is displayed in the following screenshot. In the metric Sales, the values are highpghted in different colors based on the percentage value of the sales as compared to the total sales.