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%
v-echaithra's avatar
v-echaithra
Icon for Community Support rankCommunity 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.