Problem with scatter plot

[sebix88]

Hello,

I have an excel file with 3 columns "club" i.e. Club1 (type text), position i.e. 1 (type number) and season i.e. 2024/2025 (type text). I want to create scatter plot, however currently im facing an issue with presenting those data as everything is showing one under one...as you can see in the screen. Could you please let me know what I can do to fix this issue?

[v-sshirivolu]

Hi  @sebix88 ,
The issue is that the X-axis Season is currently set as categorical text, causing Power BI to display all clubs for each season in the same vertical line.

Here are some solutions:

Use Line and Scatter/Line Chart: Navigate to the chart’s X-axis settings. Change the Type from Categorical to Continuous. This will display seasons correctly if they are in date format.

Since the season values are in a text format like "2024/2025," convert them to a date field: Create a calculated column in Power BI: SeasonStart = DATEVALUE(LEFT([Season],4) & "-07-01") (Assuming each season begins in July of the first year.) Use SeasonStart as the X-axis (continuous). or try this option  Add Club Dimension: For scatter plots: Assign Position to the Y-axis. Assign SeasonStart (numeric/date) to the X-axis. Add Club to the Details field.

This ensures each club’s data point is displayed separately rather than overlapping.

Alternative Visual: To compare club rankings per season, use a Line Chart: X-axis: Season, Y-axis: Position, Legend: Club. This approach will clearly illustrate changes in club rankings across seasons.

If the above given solution doesn't meet your requirment, please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data?How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Want faster answers? How to Get Your Question Answered Quickly - Microsoft Fabric Community

Hope this helps. Please feel free to reach out for any further questions.

[v-sshirivolu]

Hi @sebix88 ,

I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

[v-sshirivolu]

Hi @sebix88 ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you

[v-sshirivolu]

Hi @sebix88 ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

[GeraldGEmerick · Accepted solution]

@sebix88 I don't believe there is enough information here to form a rational solution. Perchance could you provide sample data?