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 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,

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

5 Replies

  • 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

  • fhill's avatar
    fhill
    Icon for Resident Rockstar rankResident Rockstar
    6 years ago

     

    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

     

     

  • negi007's avatar
    negi007
    Icon for Community Champion rankCommunity 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
      Icon for Helper I rankHelper 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
        Icon for Community Champion rankCommunity 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