Conditional formatting in MicroStrategy involves highlighting parts of the visualization, which meets some pre-defined criteria in their values. Usually in case of metrics, we want to highlight the values which are greater than a certain percentage. There can also be examples of highlighting 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 highlighting certain values when a certain threshold is satisfied. Following are the steps.
Create a grid report with the all_sales.xlsx as an example data set. Put the attributes Business line, Category in the grid along with the metric sales. Right-click the metric sales, and we get the option to choose the threshold as shown in the following screenshot.
The following screenshot shows options to choose different colors based on the percentage value of sales.
Finally, the result of applying the threshold is displayed in the following screenshot. In the metric Sales, the values are highlighted in different colors based on the percentage value of the sales as compared to the total sales.