Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Folks
I have Scatter Chart (image below). A number of the data points have the same X Y coordinates and are obscured. Can anyone suggest some tricks or tips to ensure all of the datapoints can be seen?
Cheers
Steve
Cheers
Steve
Solved! Go to Solution.
Hi Stfox,
i think u used the size and color.
i suggested to you try to add any dimension in "Play Axis"
that will help you.
Hi @stfox,
In your scenario, please try to set Start value as the minimum value of the Y-axis field and End property as maximum value of Y-axis field to see if bubbles are separated.
Also you can use the Enhanced Scatter chart visual, set different data points display as different shapes and specify shaps' rotation to separate data points as far as possible. For more information, please refer to this article: Tutorial: Enhanced Scatter charts in Power BI.
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu
Hi @stfox,
In your scenario, please try to set Start value as the minimum value of the Y-axis field and End property as maximum value of Y-axis field to see if bubbles are separated.
Also you can use the Enhanced Scatter chart visual, set different data points display as different shapes and specify shaps' rotation to separate data points as far as possible. For more information, please refer to this article: Tutorial: Enhanced Scatter charts in Power BI.
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu
Hi Stfox,
i think u used the size and color.
i suggested to you try to add any dimension in "Play Axis"
that will help you.
@stfox I think adding a legend or color saturation will allow you to distinct each of those points.
Hi Ankit
Thanks for the response. The colour saturation helps where the over lap is only patial. However, there are also a number of exact over laps where the markers have the exact coordinates. In this situation I lose visiability of the bottom marks. In Tableau I have addressed this bay making the markers a pie chart with each segment of the pie indicating a company. In other tools, there is scope to introduce a "jiggle" that slightly offsets marks with the same coordinates. But I don't think these options are available in PowerBI (yet anyway).
One approach I am contemplating is adding a "layer" slicer/filter - that allows only one unique set of coordinates per layer. The data layers can then be toggled on and off to view all records. But its not a particuarly elegant solution.
Any other suggestions out there?
Cheers
Steve
Hi Steve,
It looks like your bubbles is identical to the value on the x-axis. If that is the case - one solution could be not to set a value for the bubble size - and set the property Fill Point to On - that will give you some more space in the chart
br
Erik
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |