KB41015: How to use Gauge Band to format color in Graph View according to Y-axis value in MicroStrategy Developer 9.4.1

 
In some scenarios, it is required to display Gauge color according to Y-axis value in a Gauge graph in Strategy Desktop, as shown on page 472 of Strategy Product Manual: Advanced Reporting Guide. Part of the graph is also shown below:

 
In order to format color according to Y-axis value, Gauge Band is used. In this Technical Note, attribute Region with only Mid-Atlantic along with metric Profit Margin are used in the graph as the example. For the steps below to achieve this:
 

• Create a report with attribute Region and metric Profit Margin. A filter to is used to narrow down the element number of attribute. Run the report in Graph View and select graph type to be Advanced -> Gauge, as shown below:
  

•  
  The default graph performs like this:
  

• Right mouse click on the graph -> Graph Options, under Properties Categories -> Gauge Options -> Display, enable Bands under Gauge Band Min and Max Values to perform Gauge Range formatting. Enter Min and Max values according to metric value range for each band. Four bands are used as shown below:
  

• Click on Gauge Range 1 to 4 one by one to set the fill color of each band, as shown below:
  

• Click on OK to save the change. The graph now displays as shown below:
  

 
NOTE 1:
 
Under Properties Categories -> Gauge Options -> General -> Gauge Style, if Old style is selected as shown below:

 
The Gauge graph will perform like discussed in Technical Note:
KB10266: What are Quality Bands in Gauge Graphs and how are they set up?
 
 
NOTE 2:
 
If max and min values on Gauge graph need to be modified, right mouse click on the graph -> Gauge Options, under Properties Categories -> Axes -> Y -> Grids and Scales -> Use Manual Setting, enter Maximum and Minimum Values, as shown below:

 
To be noticed that after this operation, Gauge Band Min and Max values need to be updated accordingly.