Forum Discussion

AartiD's avatar
AartiD
Helper II
1 year ago
Solved

Bubble Chart With Categories

hi,   I am trying to cretae Bubbles Chart with quadratant categories as "Watch Out", "Concern", "Improving" & "Good". Below is screen shot of Bubble chart in Excel. X-Axis will have Mom% Growth & Y...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-karpurapud's avatar
    v-karpurapud
    1 year ago

    Hi AartiD 

    Thank you for reaching out to the Microsoft Fabric Community Forum.

     

    To create a quadrant bubble chart similar to your Excel example, assign MoM Growth % to the X-axis and YoY Growth % to the Y-axis. This will position each bubble according to hospital performance over time. Set the bubble size to represent Total Sales for the current year, and use Hospital Name as a label or legend.

    To divide the chart into quadrants labeled “Good”, “Improving”, “Watch Out”, and “Concern”, add constant lines at X = 0 and Y = 0 using the Analytics pane in Power BI. Then, create a calculated column in DAX to classify each data point by its MoM and YoY values, and use this as a Legend to color the bubbles by quadrant. To display the quadrant names, insert text boxes in each area or overlay a custom background image with the labels, ensuring your axis ranges align with the image.

    Regards,
    Karpurapu D,
    Microsoft Fabric Community Support Team.

  • v-karpurapud's avatar
    v-karpurapud
    1 year ago

    Hi,


    To show percentage values on both the X-axis and Y-axis, including constant lines, in Power BI, make sure your MoM Growth % and YoY Growth % fields are stored as decimal numbers (for example, 20% as 0.2). If required, you can create a calculated column to divide the values by 100. In the scatter chart’s Format pane, set Display Units to “None” under both the X-axis and Y-axis, and apply Percentage formatting so values appear as 0%, 20%, -20%, etc. For quadrant dividers, use the Analytics pane to add a constant line at 0 for both axes and enable their data labels, also formatted as percentages. Adjust the axis ranges as needed (such as -0.5 to 0.5 for -50% to 50%) to align with quadrant labels or background visuals.

    Regards,
    Karpurapu D,
    Microsoft Fabric Community Support Team.

ajaybabuinturi's avatar
ajaybabuinturi
Super User
1 year ago

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.