Forum Discussion
Bubble Chart With Categories
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.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.
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.
What should i do if i want % values in X-ais and Y-Axis constant lines of Power BI? As shown in below screen shot.
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.
