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...
Adding data to data model and grouping by hours new column is created as text
and it is sorted as text
Just select this column in Power Pivot and format it as Whole Number
Return to Chart, now it is sorted correctly