How to sort x-axis (Date) of Scatter chart in PowerBI

[yr112]

Dont know how to sort the order of X-axis. The data already in Date format.

[v-sgandrathi · Accepted solution]

Hi @yr112,

We're happy to assist you on the Microsoft Fabric Community Forum and Thank you @Deku for your input to the query.

If your scatter chart’s X-axis is not sorting dates correctly in Power BI, even though your column is in Date format, you need to manually adjust the sorting.

First, select the scatter chart in your report, click on the ellipsis (⋮) (More options) in the top-right corner of the visual, and choose Sort by "Tentative" (your Date column). Ensure the sort order is set to Ascending so that earlier dates appear first.

If the issue persists, go to the Modeling tab, select the "Tentative" column, and check if Sort by Column is available. If Power BI is incorrectly sorting by another column, manually set Sort by "Tentative" (itself). Unlike in table views, sorting in Data View does not affect visuals.

If your date field is still not sorting correctly, check that the X-axis type is set to Continuous in the Format pane under the X-axis settings. A Categorical X-axis might not respect date order correctly. Once adjusted, return to your report, and the X-axis should now display dates in the correct chronological order.

Thanks for reaching out! If this answer was helpful, please consider marking it as Accepted Solution and giving a Kudos, it helps the community!

Regards,
Sahasra.

[v-sgandrathi]

Hi @yr112,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Thank you.

[v-sgandrathi]

Hi @yr112,

we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.

If our response addressed by the community member for  your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.

Thank you for being a part of the Microsoft Fabric Community Forum!

[v-sgandrathi]

Hi @yr112,

Following up to check whether you got a chance to review the suggestions given. If the issue still persists please let us know. Glad to help. 

Thank you.

[Deku]

Select the visual and a header will appear, click on the ...

Then select sort by and then by date