Forum Discussion
Scatter plot
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.- Add Markers
- Lines > Colors > Transparency 100%
Super UserIf 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.
- Add Markers
- Lines > Colors > Transparency 100%