Forum Discussion

Lovebo01's avatar
Lovebo01
Icon for Helper I rankHelper 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

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
6 years ago

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