Forum Discussion

spartan27244's avatar
spartan27244
Icon for Resolver I rankResolver 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.

Need Help
  • HashamNiaz's avatar
    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

3 Replies

  • HashamNiaz's avatar
    HashamNiaz
    Icon for Solution Sage rankSolution 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's avatar
      spartan27244
      Icon for Resolver I rankResolver 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's avatar
        HashamNiaz
        Icon for Solution Sage rankSolution 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