Forum Discussion
RickJani
4 years agoFrequent Visitor
Line chart not sorting by quarter
My data does not have dates (So I can't connect dates with calendar table to get quarter). But My data has quarter, Year and total sales columns. I have created a line chart and now trying to sort it...
- 4 years ago
i got my answer. On the visual, top right hand side if you click on 3 dots, it gives you an option to sort by axis and choose Year-Quarter which is the column selected for x -axis and it now sorts correctly.
claymcooper
4 years agoResolver II
Can you share a screenshot of the line chart so I can get a better understanding of the problem?
Thanks!
RickJani
4 years agoFrequent Visitor
i got my answer. On the visual, top right hand side if you click on 3 dots, it gives you an option to sort by axis and choose Year-Quarter which is the column selected for x -axis and it now sorts correctly.