KB322689: How to format the DHTML Heat Map widget to have custom color ranges in a Report Service Document in MicroStrategy Web

The DHTML version of the Heat Map widget does not have a configuration menu, like the flash based widget did. However it is still possible to change the color ranges by using thresholds applied to the second metric of the dataset. Follow these steps to format the DHTML Heat Map widget to have custom colors ranges in a Report Service Document in Strategy Web 10.x.
 
ACTION:
The DHTML Heat Map widget can be configured as below:

• In a document, insert a grid with one attribute and 2 metrics.
• Access the grid properties by right clicking the grid and selecting Properties and Formatting.
• From the Widget selection menu, select Widget > DHTML > Heat Map, as shown below.
  

• Run the document in Editable mode.
• Right-mouse-click on the second metric in the grid > Thresholds > Advanced.
• Define a threshold condition.
• Modify the formatting by going to Color and Lines > Fill, and select the color, as shown below:
  

• Repeat the step above to create a series of threshold conditions to define the appropriate ranges.
  For instance range 1 could be 0 - 10,000 = Red.
  Range 2 could be 10,000 - 20,000 = Green.
  

• Save the document and run it in Presentation mode. Note that the custom color defined in thresholds is correctly applied to the Heat Map widget.
  

 
The Strategy Internal Reference Number for the issue discussed in this technical note is DE20939.