Forum Discussion

Icon for Resolver I rank

Resolver I

5 years ago

Solved

Sort different on graph than in grid

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

HashamNiaz
5 years ago
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

Icon for Solution Sage rank

Solution Sage

5 years ago

Hi spartan27244 !

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

Regards,

Hasham

spartan27244
Resolver I
5 years ago
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
  Solution Sage
  5 years ago
  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