Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have added a new column Lead Time created using DATEDIFF in the Data view using modelling tab. When I tried to create a column chart with lead time on x axis and count of lead time on y axis it's plotting the columns randomly. I tried changing the axis type to categorical and also checked that the data type is also right as whole number. I want the x axis to be in ascending order like 0,4,5,6,...17,18.
Can you help where am I going wrong?
And also the created column in data view is not showing up in the power query editor. I created it in data view becuase the custom column in power query editor is not recognizing DATEDIFF().
Appreciate your help!!
@Anonymous
Have you tried to sort the visual by the column on X-axis..?
Yes I tried that but nothing changes on the chart. I think it's already sorted out by the column but in descingding order. It's not getting sorted in ascending order.
User | Count |
---|---|
124 | |
106 | |
99 | |
63 | |
59 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |