Forum Discussion
Area Chart Displaying Times in wrong order
I have an area chart I created to displaying average call times from UCCX call system data brought in from Azure Synaspe that does the intergers by descending or ascending. I should mention I also converted the times from UTC to PST. The numbers are not displaying in numerical order and I can't seem to fix it. Any suggestions would help.
Hi Bryanpuentes00 ,
It appears that the [Time] column is being sorted by text in descending order. For sorting of text types column, auxiliary columns/tables are generally used to help determine the order of alignment.
You might consider going to add secondary columns in PowerQuery and sorting by secondary columns in Desktop.
Sort one column by another column in Power BI
Sort a Column with a Custom Order in Power BI
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
1 Reply
Hi Bryanpuentes00 ,
It appears that the [Time] column is being sorted by text in descending order. For sorting of text types column, auxiliary columns/tables are generally used to help determine the order of alignment.
You might consider going to add secondary columns in PowerQuery and sorting by secondary columns in Desktop.
Sort one column by another column in Power BI
Sort a Column with a Custom Order in Power BI
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum