Forum Discussion
X-axis labelling time intervals Line & Clustered Column Chart
Amit, Greg , tamerj1 , lbendlin I have made a Line & Clustered Column Chart where my X-axis labels are timeclocks starting from 0, 1, 2, all the way to 23. However, when I add the Line & Clustered ...
Make the visual wider, or change the x axis type to categorical (NOTE: that will eliminate the gap).
lbendlin
Super User
Super UserMake the visual wider, or change the x axis type to categorical (NOTE: that will eliminate the gap).
But if the X-axis is changed into AM and PM format using the DAX IF code, how do we sort the X-axis in a chronologial order from 12:00 am, 1:00 am, 2:00 am......11:00 pm? When we sort the X-axis in ascending order PowerBI reads like this:
Looks like PowerBI reads only the number in ascending order ignoring the AM & PM. Do you know how to fix this issue?
- lbendlin
Have another column with the numeric hour values. Sort your x axis column by that numeric column.