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 th...
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%
Deku's avatar
Deku
Icon for Super User rankSuper 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,