Forum Discussion
Power Query/Pivot - Hours not in chronological order
Hi Masters. I am trying to create a bar graph to visualize the sum of calls we receive per every hour chronologically using Power Query. I have tried to created it on normal excel pivot and experienc...
Sorting will not be as expected if the hours stored in the columns are Text entries.
To see if the Hours are stored as Text in the Hour column, assuming your hour is in B2, place the formula =ISNUMBER(B2) in a blank cell and see what does it return?
if it returns False that means the Hours are stored as Text but not as real numbers.
How are you extracting the Hours from the Date column? Do you use a formula? If yes, what's that formula?