Scatter plot

[fraspillaga]

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?.

[v-echaithra]

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.

[andrewsommer · Accepted solution]

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]

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.

[fraspillaga]

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,