Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Scatter plot

Hi Community,

I am relatively new to Power BI, having been using Spotfire and Tableau for years. How can I make an Excel chart where the X axis shows the name of the trucks, and the Y axis shows the target value and the actual value?.

 

 

 

Need Help
  • andrewsommer's avatar
    andrewsommer
    1 year ago

    If you want to show the actual alpha name and not the numeric name (i.e. Ford F-150 instead of 1) then that is not possible.  The scatter plot in Power BI requires numeric values on the x and y axis.  If you are okay showing the numeric value for trucks on the X axis then just use the native scatter plot

    However, you can work around this by creating what you want using a line chart.  Put your truck alpha name on the X access and your target and real values on the y-axis.  Then you just need to format to get what you want.

    1. Add Markers
    2. Lines > Colors > Transparency 100%

4 Replies

  • Deku's avatar
    Deku
    Super User
    1 year ago

    Assume you mean Power BI rathan than Excel since this is Power BI forum

     

    Have a table with truck, Category and Value. Cateory is either Target or Acutal.  Truck on X-axis, Category in Legend and Value in Y-axis.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi Deku,

       

      Thank you for your help.

      1) How do I make the X-axis show only the truck numbers that exist. If I put "Truck" on the X-axis, the number 8 appears (truck number that does not exist).
      2) If I have to have a column where it says "Target" or "Actual", does that mean I should modify my base table? This can't be done without modifying it?.

       

      Thanks,

  • andrewsommer's avatar
    andrewsommer
    Super User
    1 year ago

    If you want to show the actual alpha name and not the numeric name (i.e. Ford F-150 instead of 1) then that is not possible.  The scatter plot in Power BI requires numeric values on the x and y axis.  If you are okay showing the numeric value for trucks on the X axis then just use the native scatter plot

    However, you can work around this by creating what you want using a line chart.  Put your truck alpha name on the X access and your target and real values on the y-axis.  Then you just need to format to get what you want.

    1. Add Markers
    2. Lines > Colors > Transparency 100%
  • v-echaithra's avatar
    v-echaithra
    Community Support
    1 year ago

    Thanks andrewsommer  for Addressing the issue.

     

    we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
    If our user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

     

    Regards,
    Chaithra E.