Dynamically resizing bubbles based on data values on powerbi

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!