Forum Discussion

Lovebo01's avatar
Lovebo01
Helper I
6 years ago
Solved

Scatter chart X-axis with text value

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 ...
Need Help
  • negi007's avatar
    negi007
    6 years ago

    @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
    scatter.PNG

negi007's avatar
negi007
Community Champion
6 years ago

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's avatar
Lovebo01
Helper I
6 years ago

Hi,

Thank you all for your responses,

 

Here a set of data :

sizecolorsales
1red30
2blue5
3red25
4blue12

 

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's avatar
    negi007
    Community Champion
    6 years ago

    @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
    scatter.PNG