Scatter chart not sorting X axis on month name

gauravtomer Tough to say exactly, screen shots might help. 

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

Hi gauravtomer ,

" But X axis is not sorting on month name even when I have made Month Name to Sort by Month number. In same diagrm if I am using Month Number then it sorts correctly."

(1) If your [Month] column comes from a calculated column, The visual will automatically sort for you.

Month_name = table[Date].[Month]

(2) If your [Month] column is the source data, it can not be sorted correctly.

"I dont see all the company names and it shows that "i" sign above the chart on right corner saying cant display all the company names, but when I do the same with Month Number then it shows all the comapny names and its values."

You try to stretch the picture a bit larger.

Please refer to my sample .pbix file.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi gauravtomer ,

Has your problem been solved?

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Not sure who is responsible to design the scatter charts in PowerBI Desktop. In the X-axis, there is no. of items it can sort if your X-axis had only 8 items. If more than that it can't sort. I am not sure it was a limitation or was it a design error. I hope MS Power BI Desktop could correct the limitation/error.

how come this basic functionality is not yet fixed by powerbi? its clearly a bug. you cant sort the X axis when you have measure in Y axis and some field in a Legend.