Ordering Axis on a LineChart Visualization - DirectQuery Mode

[a_dr50]

Hello,

  I have an issue ordering the axis on the following visualizations:

Both visualizations are the same type and the information displayed is from the same table.

Now, Is there a way or a property which could be set for ordering the Axis data?, as I am working in a DirectMode query the "Sort by Column" option from the Modeling menu is not avalaible.

Any help is appreciated.

BR

[Anonymous · Accepted solution]

@a_dr50 try with the options of the chart, clic on the 3 dots

[a_dr50]

Hello @Anonymous , thanks for your recomendation.

I did not notice the options of the chart on the 3 dots, I supposed it was a configuration defined at the format or value properties of the visualization.

But looking at the options of the chart:

• You can order the the axis either by field set at the Axis property or by the fields set at the numeric amount to plot (Value).
• There is only a way to order the option selected, descending.

About the last statement, I guess is a limitation of this "visualization", to me is easier to read from de lowest value to the left to the higuest to the right.