Forum Discussion

Giada90's avatar
Giada90
Helper IV
1 year ago
Solved

bubble changed dimension by value

Hi, is it possible to have a kpi inside a circle that changes as dymension based on number? (big circle for big numbers) thanks
  • v-menakakota's avatar
    1 year ago

    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.