Scatter chart X-axis with text value

[Lovebo01]

Hi everyone,

I am trying to use a scatter chart and have some numerical value on Y-axis and text value on X-axis, but when I am trying to do this, I have this error message : "Your x- and y-axis values aren't playing together nicely. Replace the x-axis field with a numerical value, or change the y-axis field values to summarizations."

Separately I can show an X-axis with text value and some indcators for the size, but if I add an Y axis numerical I have this error message.  

Do you know why ? How can I fix this issue ?

Thank you,

Lovebo,

[negi007]

@Lovebo01 To create scatter plot, one of the axis has to be a calculated field/numeric field. Can you please share your data and what you wish to see on the scatter plot.

[Lovebo01]

Hi,

Thank you all for your responses,

Here a set of data :

size	color	sales
1	red	30
2	blue	5
3	red	25
4	blue	12

And the graphic that I want to do :

The size of the bubble depends on the value "sales".

@fhill I tried to apply your solution with the line chart but with 2 axis I don't know if it's possible, the size of the marker can depends on another value ?

Thank you,

Lovebo

[negi007 · Accepted solution]

@Lovebo01 You can perform the steps below to create the scatter plot that you want to have

1. Create a calculated column:

Color_Code - IF('Scatter chart'[color]-"Rojo",1,2)

2. Then plot the data as below screenshot shown. Start both axes from zero values

[fhill]

The nature of a Scatter Chart required numberic values on both the X and Y axis, BUT have you tried creating a Line Chart where the Stroke Width is set to 0, and the Show Marker is turned on with default circles?  I think this may be closer to what you want?

(I have a scond Y axis in the demo example below, but you can play around with the values?)

Forrest

[Pragati11]

Hi @Lovebo01 ,

Try using a summarisation on Y-axis field like AVERAGE or SUM.

See if that displays results correctly.

Also do share screenshots of your chart.

Thanks,

Pragati