KB213643: How to add a pair of threshold lines in a bubble graph in MicroStrategy Analytics Developer

In some business scenarios, a need to add a pair of threshold lines in a bubble graph to distinguish expected and abnormal values may arise.  Those located in between the lines are with expected values, and those locates outside the lines are abnormal. This tech note introduces a solution for this requirement.
 

• Create a report with Subcategory, Revenue, Profit and Cost;
• Switch to Graph View and choose Bubble DualAxis as the graph type;
• RMC on the graph, and choose Graph Options;
• Go to Axes ->Y2 and choose “use manual setting for maximum value” option and enter a value that is the same as the one shown underY1 tab;
  

• Choose “Draw Custom Lines at” and enter the upper limit value to set up one of the threshold lines;

• Go to Axes -> Y2 -> Grids and Scales -> Customlines and choose red color for the line;
• Go to Axes -> Y1, choose “Draw Custom Lines at” and enter the lower limit value to set up the other threshold line;

• Go to Axes -> Y1 -> Grids and Scales -> Customlines and choose red color for the line;
• Go to Axes -> Y2 -> Axis Labels and uncheck “Show Labels for this Axis” to hide the Y2 axis label;
• Go to Titles -> Value Title (Y2) and modify the transparency to be 100% to hide Y2 axis title;

• Click on Apply and it shows graph as below. All the bubbles in between the two lines are with expected results and the others are not.