Sort different on graph than in grid

[spartan27244]

Can anyone tell me why PowerBI decided to sort these differently ... note the graph ends with 2017f while the grid sorts propery.

[HashamNiaz]

Hi @spartan27244 !

Please makesure you are sorting both visual on same [column] / measure and sorting order is same ASC/DESC

Regards,

Hasham

[spartan27244]

The Axis for the Graph is the Same field as the first field in the grid. So they sort the same, also exaplain why on the Grpah axis it would move 2017f to the right of the other 3 that are in order.

[HashamNiaz · Accepted solution]

Hi @spartan27244 !

You can Line chart, and set X-Axis property to Categorical, this will allow you to sort you axis based on Column / measure.

SortOrderCategorical

Regards,

Hasham