Sort X-Axis values on bar chart report

[MdAnwarAhmed]

Hi All,

In the report I've prepared, I need to arrange the values on the X-axis of the bar chart in a sorted order.

Actually, I have created a database view on following tables

Any input or suggestions offered would be greatly appreciated.

[driveseedsi]

Hi MdAnwarAhmed,

To sort the X-axis values on your bar chart, you can typically find an option within your chart settings to sort the data. Look for options like "Sort by X-axis" or "Order by values" in the chart properties. This should help you achieve the desired order.

Best regards.

Traffic Ticket Lawyer

[MdAnwarAhmed]

I'm having trouble locating the options you mentioned. Could you please provide more specific guidance on where I should be looking?

[AndersBGS]

Hi @MdAnwarAhmed ,

When you open the condition builder from the report itself, you will see the sort button as shown below:

if  my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[MdAnwarAhmed]

Hi @AndersBGS 

I have tried the method you suggested but I think it will not work. I am not getting the required field to sort. I want the Display values to be sorted on x-axis but this way I am not getting the option to sort on Display value.

Also, after adding the sort, getting waring.