Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |