How to dispay Line and bar chart Direct query data in the descending order

[Anonymous]

Hi Community,

I am working with live data(Direct Query). I wanted to plot the number of events that occurred every hour for the last 48 hours broken down by each hour. I am able to plot the data but I am print the X-axis in descending order. My plot looks like this:

Here I want to print the X-axis from 48 to 1 instead of on 1 to 48. Could anyone kindly let me know how to plot the X-axis in descending order. 

Many thanks in advance

[edhans · Accepted solution]

In the upper right of the chart, click on the ellipses and the sort icon and sort by the hours column, descending. It has to be text though.

It cannot sort the axis of a chart if the axis is numerical, it always goes ascending.