Forum Discussion
Overlapping text on a scatter chart
- 2 years ago
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!!
- 2 years ago
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 measureTop 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.
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.