KB37708: How to apply threshold color on Map widget when running a Report Services document in MicroStrategy Web 9.x?

The following steps describe applying threshold color on Map widget when running a Report Services document with Strategy Tutorial project in Strategy Web 9.x:
 
 

1.  In Strategy Web, create a new report with attribute Store in the row and metric Cost in the column.
2. Create a new dashboard using report created at step 1 as dataset.
3. Insert a Map widget into the dashboard created at step 2. Add the attribute Store in the row and the metric Cost in the column.
4. Right click the Map widget and select "Properties and Formatting".
5. Click "Widget Properties" from Properties>Widget, as shown below:

​

 
 
6. Choose the radio button "Use dynamic bubbles" under Marker style/mode section and check the "Apply threshold for the map" box, as shown below:
 

 
 
7.Run the document in Edit mode. Right click the metric Cost and select Thresholds>Advanced, add threshold on Cost value which will change the background color of cells, as shown below:

 
 
8.Run the document. Note that the threshold is applied, as shown below:

Note: At step 7, if using cells font color instead of background color when adding threshold color on metric value, as shown below:
 

 
Run the document, the dynamic bubbles will show as black ones, as shown below: