Dynamically resizing bubbles based on data values on powerbi

[dlv_35]

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,

[BeaBF]

@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!

[grazitti_sapna]

Hi @dlv_35 ,

Try this:

1. Create an order column:
   StageOrder =
   SWITCH(
   [Stage],
   "Harvested", 1,
   "In Transit", 2,
   "Delivered", 3,
   99
   )
2. Go to Visualizations pane → select Scatter chart.
3. 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!