Category labels in bubble chart

[Cezmeister]

Hi there,

I have a bubble chart that has around 30 bubbles on it, each representing a project. Each project has been measured and plotted based on two criteria - profit (on the x axis) and risk (on the y axis).

When I turn on category labels, it displays the profit and risk scores for each bubble. However, I want the label to display the name of the project, which is another field. I want this shown permanently on the graph, rather than only displayed when hovering (which tooltips can do). I can't find a way to do this simply, but is there a method using DAX to override the category label without impacting on what the chart uses for x and y axes values?

Many thanks

Ceri

[v-piga-msft · Accepted solution]

Hi @Cezmeister,

It seems that there is no dax formula for us to override the category label.

Actually, if you drag Project Name to the Details field or legend field, then it will show the lable beside the bubble.

Best Regards,

Cherry

[Cezmeister]

Hi Cherry,

Thanks so much for that! It has worked perfectly.

For anyone else who has the same problem and is reading this - when I originally tried to put my project name field in Details, I had the errror message "remove details to display x and y-axis pairs. Alternatively, you can keep Details and set an aggregate for x- and y-axis." It was because my x and y axes values were set to "don't summarize" and Power BI couldn't work with them. I instead set them to "average" and it worked perfectly.

Many thanks,

Ceri

[jenalc]

@CezmeisterThis solved my issue! Thank you so much for posting the follow-up!