Scatter plot - same number gets reflected across X-axis

[Anonymous]

Hello,

I have created a scatterplot comparing internal data (Y axis) and target market data (X axis). When I toggle through slicers, in a few cases, the x-axis would show the same data point at 3 different places and bubbles split across the 3, refer screenshot below. Ideally, this should form like a single column.

#help

[Anonymous · Accepted solution]

Hi @Anonymous 

You need to have a table, the structure like the following table

Output

Best Regards!

Yolo Zhu

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

[Anonymous]

@amitchandak