bubble changed dimension by value

[Giada90]

Hi,

is it possible to have a kpi inside a circle that changes as dymension based on number? (big circle for big numbers)

thanks

[Giada90]

thanks!

[v-menakakota · Accepted solution]

Hi @Giada90 ,
Thank you for reaching out to us on the Microsoft Fabric Community Forum.

Scatter Chart is the best solution for this, which i have tried it on my end .Tried with the sample data of Category,KPI values. To center the circles in the scatter chart, create these measures:

X-axis:

X_Axis = 1

Y-axis:

Y_Axis = 1

Add the field mappings

X_Axis:X_Axis

Y_Axis:Y_Axis

Size: KPI Values

Details: Category

Now goto scatter chart and play the pause button ,will be able to see the size of the button changing according to the KPI vales of the Category
As the KPI value for Sales is high the size of the button is increased and the KPI value for HR is low then the size of the button is decreased.
Please go through the screenshots and pbix file for more clearence:

If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.
Thank you and Regards,
Menaka Kota.

[MamathaPatlolla]

Yes, it's possible to have a KPI inside a circle that dynamically changes in size based on the number. 

There are 2 methods 

1. Custom Visuals – Use the "Deneb" custom visual (based on Vega-Lite) to create a dynamic circle size.

2. SVG in Tables – You can generate a circle using an SVG formula in a measure and use that inside a table.

[Giada90]

@MamathaPatlolla thanks, could you explain me the method of svg in tables? thanks

[v-menakakota]

Hi @Giada90 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-menakakota]

Hi @Giada90 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.