topic Re: Dynamically resizing bubbles based on data values on powerbi in Custom Visuals Development Discussion

Dynamically resizing bubbles based on data values on powerbi

dlv_35 — Mon, 15 Sep 2025 13:00:05 GMT

Hi everyone,

I’m building a fruit-inventory dashboard and want to show each stage of our banana supply chain as a bubble. For example:

Harvested Bananas: 10 crates
In Transit: 80 crates
Delivered: 50 crates

Each stage is represented by a bubble, and I’d like the bubble size to grow or shrink automatically according to the count—so “In Transit” would appear largest when it has 80 crates, and “Harvested” smaller with only 10.

I previously tried the Akvelon Power BI visual, but I couldn’t get the bubble size to respond dynamically to the measure. The layout should display the stages sequentially (1-2-3…) while each bubble scales with the underlying data.

What’s the best way to achieve this in Power BI? Would you recommend a custom visual, a DAX measure trick, or another built-in visual? Any guidance or examples would be greatly appreciated.

Thanks,

Re: Dynamically resizing bubbles based on data values on powerbi

BeaBF — Fri, 26 Sep 2025 14:03:47 GMT

@dlv_35 Hi!

Add a Scatter Chart visual to your report.
Put your “Stage” field in the Details bucket.
Put an index (or just Stage again) in the X-Axis to force ordering.
Put a constant (like 1) in the Y-Axis to keep everything aligned horizontally (or vertically).
Put your measure (e.g., [Crate Count]) into the Size bucket.
Set the marker size scaling in the Format pane → “Shapes” → “Size” to something comfortable.

If you want more control (labels inside bubbles, better spacing, tooltips), the free Bubble Chart by OKViz is well regarded and supports dynamic sizing natively.

BBF

💡 Did I answer your question? Mark my post as a solution!

👍 Kudos are appreciated

🔥 Proud to be a Super User!

Re: Dynamically resizing bubbles based on data values on powerbi

grazitti_sapna — Mon, 29 Sep 2025 17:42:45 GMT

Hi @dlv_35 ,

Try this:

Create an order column:
StageOrder =
SWITCH(
[Stage],
"Harvested", 1,
"In Transit", 2,
"Delivered", 3,
99
)
Go to Visualizations pane → select Scatter chart.
Drag fields:

X-axis → StageOrder
Y-axis → create a dummy measure Always1 = 1 so all bubbles align in a row.
Size → Crates (this makes bubbles grow/shrink).
Legend / Details → Stage

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.

💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.

🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.

🔗 Curious to explore more? [Discover here].

Let’s keep building smarter solutions together!

Re: Dynamically resizing bubbles based on data values on powerbi

julliaz — Sat, 18 Oct 2025 08:14:32 GMT

Option 1: Use the Built-in Bubble Chart Visual

This is the simplest approach if you just want proportional sizing

Create a table like this:
Stage Crates
Harvested 10
In Transit 80
Delivered 50
In Power BI:
- Insert a Bubble Chart (or a Scatter Chart).
- Drag Stage to the Details or Category field.
- Drag Crates to the Size field.
- Optionally, use a constant or index for X-axis to keep stages in order (e.g., 1, 2, 3).
Adjust bubble size scaling under Format → Bubbles → Size controls to make the difference visually clear.
Need More Help Visit Here

Harvested	10
In Transit	80
Delivered	50