The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Solved! Go to Solution.
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 Team
If 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
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 Team
If 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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
81 | |
63 | |
56 |
User | Count |
---|---|
247 | |
122 | |
110 | |
77 | |
72 |