Forum Discussion
Power BI Sorting
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.
3 Replies
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.
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,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,
