Scatter chart not sorting X axis on month name

1 have 2 issues 1. I created a scatter chart with Month Name of X axis, company name as legends and Y axis as sales. But X axis is not sorting on month name even when I have made Month Name to Sort...

Need Help

v-lionel-msft

Community Support

6 years ago

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.