Overlapping text on a scatter chart

[DougHood]

I am isolating the top 1% of overtime earners by employee and adding the job title. The problem is that it becomes unreadable when the data points are close together. Is there a way to stop the title from displaying if it will overlap on another? Just looking to thin them out so it is more readable.

Thanks,

Doug

[Ritaf1983 · Accepted solution]

Hi @DougHood 
Unfortunately no, the best thing to do in the described scenario is not to show the labels on the tooltip.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[shafiz_p · Accepted solution]

Hi,@DougHood  You can increase the readablity of your scatter chart by disabling color by category. Coloring this way not very much usable. Also, try changing y axis minimum value, it's better to start from 0%. You can set the marker style to border only. Also try changing category label color, background color and transparency. You can also try to change x axis min and max value to see label adjustment.

Other way to create enhance scatter plot with the help of Jitter and ggrapel using R script in power bi.

Hope this helps!!

[sroy_16 · Accepted solution]

Hello,

There are many ways how you can achieve this, however Power Bi natively does not support this so you have use the workarounds.

1. Apply Conditional Formatting: Display labels only for the top N items or based on certain conditions.
Create a measure

Top 1 Percent Label =
VAR Rank = RANKX(ALL('Employee'[Employee Name]), [Overtime Earned], , DESC)
RETURN IF(Rank <= 0.01 * COUNTROWS(ALL('Employee')), [Job Title], BLANK())

Use this measure in conditional formatting to show or hide labels based on criteria.

2. Use Data Label Formatting:

Position Labels Strategically: Sometimes, moving the label position can help avoid overlaps.
Go to Format > Data labels.
Adjust the Position setting (e.g., choose between Inside End, Outside End, etc.).

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[shafiz_p · Accepted solution]

Hi,@DougHood  You can increase the readablity of your scatter chart by disabling color by category. Coloring this way not very much usable. Also, try changing y axis minimum value, it's better to start from 0%. You can set the marker style to border only. Also try changing category label color, background color and transparency. You can also try to change x axis min and max value to see label adjustment.

Other way to create enhance scatter plot with the help of Jitter and ggrapel using R script in power bi.

Hope this helps!!

[Ritaf1983 · Accepted solution]

Hi @DougHood 
Unfortunately no, the best thing to do in the described scenario is not to show the labels on the tooltip.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly