This discussion is archived
1 Reply Latest reply: Oct 11, 2013 3:31 AM by AjithPathiyil RSS

Sort Order in Bar Charts

RajD Newbie
Currently Being Moderated

Hi Guys,

 

I am new to BI so a quick and easy question to you all experts.

 

I have a Horizontal Bar Chart on my rtf template.... but my Y axis is not getting sorted properly...

 

I have data on my Y axis as

Period - P1,  P2, P3, P4, ...... P10, P11, P12, P13

I have a order column too

Order -  1,2,3,4....10,11,12,13

 

But my chart is getting displayed in

P1,P10,P11,P12,P13,P2,P3...P9

 

Can you please guide me on how to get Y axis ordered.

  • 1. Re: Sort Order in Bar Charts
    AjithPathiyil Newbie
    Currently Being Moderated

    Hi Raj,

     

    The query used for displaying the Y axis should have a "order by period" clause.

     

    e.g. If below is the query used to display the Y axis by you.

     

    select period r, period d from <TABLE> ;

     

    Change it to something like below

     

    select period r, period d from <TABLE> order by period;

     

    Hope this helps, If yes mark it as answered please.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points