Forum Discussion

bcastillo's avatar
bcastillo
Frequent Visitor
8 years ago
Solved

Issues with order in column

Hello,    I am working on a line chart and the x-axis is supposed to have rolling quarters but power bi is sorting the quarters for me and they are out of order. Here is the picture of my data and ...
Need Help
Tips and Tricks
Tutorial Requests
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    Hi bcastillo

    I can reproduce your problem.

    My "Quarterly data" column is of text type, when I add it to the axis of the line chart,it will sort by another column of number type by default. picture below is an example.

     

    One workaround is:

    create a Index column in Query editor

    Then in Report View, select "Quarterly data" column, then select on the Modeling->Sort by column, click on the "Index" column.

    Next on the Line chart, select the three dots on the upper-right of it, select "Sort by"->"Quarterly data".

     

     

     

    Best Regards

    Maggie

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi bcastillo

I can reproduce your problem.

My "Quarterly data" column is of text type, when I add it to the axis of the line chart,it will sort by another column of number type by default. picture below is an example.

 

One workaround is:

create a Index column in Query editor

Then in Report View, select "Quarterly data" column, then select on the Modeling->Sort by column, click on the "Index" column.

Next on the Line chart, select the three dots on the upper-right of it, select "Sort by"->"Quarterly data".

 

 

 

Best Regards

Maggie