Power BI Sorting

[SyVe]

Hi everyone,

I'm creating a report with filtering, plots and statistics and I am facing one issue. How to sort X axis in the scatter plot ?

I'm creating a Scatter plot from scratch and on X axis I have Iteration paths and my Y axis is Cycle times for items. I have sorted Iteration paths in Column, in the filter and on the plot, but in reality it is not. I'm providing a 2 screenshots, one is filter sorting and the other one is plot in reality.

Thank you in advance

P.S. Sorted on the plot as well. Three dots Sort by ascending or descending.

[v-lid-msft]

Hi @SyVe ,

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,

[v-lid-msft]

Hi @SyVe ,

Since the sort order in slicer seems customize, we think you have sort the x-axis by another sort column properly. Could please check if the scatter chart is sort by the x-axis? Or  try to reproduce the same issue on the sample file we shared?

By the way, PBIX file as attached.

Best regards,

[amitchandak]

@SyVe 

This is a text column and if and if you do not want change sort column, you need to create a sort column for this column and mark that as sort column for that

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

Sort Asc and Sort desc should sort otherwise.