Hi, I want to create a bubble and based on the count it should increase. How can I achieve this pbi

[Olufemi7]

Hello @Jyothirmayi, 

Yes this can be done in Power BI and Microsoft Fabric (Power BI reports in Fabric) using a Scatter chart.

 How to Make the Bubble Increase Based on Count

Insert a Scatter chart visual.
 Create a count measure, for example:

Bubble Count = COUNTROWS('YourTable')

Or for distinct values:

Bubble Count = DISTINCTCOUNT('YourTable'[ColumnName])

Assign fields:

• X Axis → Numeric field

• Y Axis → Numeric field

• Details → Category (e.g., Customer, Product, Region)

• Size → Your Bubble Count measure

The Size field controls the bubble size. Larger counts automatically produce larger bubbles.

This works the same way in Power BI Desktop, Power BI Service, and Microsoft Fabric reports, since Fabric uses the same Power BI visualization engine.

Microsoft Documentation

Scatter and bubble charts in Power BI:
https://learn.microsoft.com/power-bi/visuals/power-bi-visualization-scatter

The documentation confirms that the Size field adds a third measure that determines bubble size.

In summary:
Use a Scatter chart + Count measure in the Size field.

[BeaBF]

@Jyothirmayi Hi! Please can you share some details? And also paste data.

BBF

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

👍 Kudos are appreciated

🔥 Proud to be a Super User!