On the right-hand side with the chart selected, go to the Sorting section. You'll need to drag the name of the meansure to the top. for example in the screenshot below you can see that the first sort is by Customer. If I wanted to arrange largest sales first, I'd drag Sales above Customer. You'll then be able to click the expansion arrow and change Sorting from auto to Ascending.
Did you want to disregard the blanks also?
There is a work-around here - multiple your X-Axis value by -1 and sort in ascending order:
Click the screen shots to enlarge
Please mark the appropriate replies as helpful / correct so our team and other members know that your question(s) has been answered to your satisfaction.
Hello Luke, Michael,
I have tried the different sorting alternatives to no avail. I also now have tried the tip from you Michael. Sadly it doesn't give an appropriate result, see below:
What can be the issue here? I have loaded a fairly large file (ca 15000 rows 67 columns) from Excel as a csv (when I did it direct as an excel file the dates where converted to the MS code number instead of it being a date, go figure?)
It's quite interesting case and unusual. Would it be convenient to share the QVF file or the source data sample? If not, could you try to only load limited rows (as if 'sampling data') in your script to avoid 'impurities' data points? Hopefully this would help you for debugging.