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
Can you please guide me on how to get Y axis ordered.
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.