Bubble Chart With Categories

Hi AartiD,
I am asueming, you want to create a same chart in Power BI. You can follow the below steps.

1. Use Scatter chart to recreate it. 
2. Add fileds as below
   Values = Not required for this
   X-Axis = MoM Growth %
   Y-Axis = YoY Growth %
   Legend = Hospital Name or Quadrant Label
   Size = Sales
   Tooltips = Based on business requirement
3. Add Quadrant Labels as Shapes or Add or create background image as is which is in excel and add it to the chart.
   

   Add shapes and text boxes manually:

   • Use rectangles for background colors and place text 

   • Use dynamic quadrant logic in a calculated column as below

Quadrant = 
SWITCH(TRUE(),
    [MoM%] > 0 && [YoY%] > 0, "Good",
    [MoM%] > 0 && [YoY%] <= 0, "Improving",
    [MoM%] <= 0 && [YoY%] > 0, "Watch Out",
    "Concern"
)

You can then color bubbles by Quadrant using Legend = Quadrant

Add background image to the chart:

• Select the scatter chart

• Go to Format pane > Plot area > Image

• Upload your image and set transparency = 0

• Adjust X and Y axis limits to match the quadrant lines in the image

Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.

Hi AartiD ,

You can definitely recreate this quadrant bubble chart in Power BI. Let me break it down step by step:

Step 1: Create the basic scatter chart

• Use a Scatter chart visual
• X-Axis: MoM Growth %
• Y-Axis: YoY Growth %
• Legend: Hospital Name
• Size: Total Sales
• Values: Leave empty

Step 2: Add quadrant logic Create a calculated column to identify which quadrant each hospital falls into:

Quadrant = 
SWITCH(TRUE(),
    [MoM Growth %] >= 0 && [YoY Growth %] >= 0, "Good",
    [MoM Growth %] >= 0 && [YoY Growth %] < 0, "Improving", 
    [MoM Growth %] < 0 && [YoY Growth %] >= 0, "Watch Out",
    "Concern"
)

Step 3: Add the quadrant labels and lines This is where it gets tricky. You have two options:

Option A: Manual shapes (easier)

• Add text boxes on your report page with "Good", "Watch Out", etc.
• Position them in the corners
• Add reference lines at X=0 and Y=0 from the Analytics pane

Option B: Background image (cleaner look)

• Take a screenshot of your Excel quadrant background
• In scatter chart Format pane → Plot area → Image
• Upload your background image
• Set transparency to around 30-40%
• Make sure your axis ranges match the image

Pro tip: Use the Quadrant column in your Legend field instead of Hospital Name if you want bubbles colored by quadrant category.

The key is getting those reference lines at 0,0 to divide your chart into the four sections.

Hope this helps clarify the process!

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.

This response was assisted by AI for translation and formatting purposes.

I am not able to understand from Step 3.