Forum Discussion
Date (Year & Quarter) Sorting in a Graph
Hi All I've got a supply and demand graph. Numbers wise my supply is a positive number and demand is a negative. The source is an excel spreadsheet. One of my columns is a text field which has fo...
Hi Anonymous ,
System Undersatnd ordering based on String data type because it's look like there are no seperate columns for year and It's Quarters.
Easy way to do it by creat indexing for Year/Qn column. and set created index column as order referance for Yr/Q column.
Check this: https://www.youtube.com/watch?v=4xapOrfLvbg
Keep Going
Best Regards,
Nirav
v-lionel-msft
Community Support
Community SupportHi Anonymous ,
If your X-axis column is a text type, you have to use the "Sort by column" feature to sort it, so I suggest you use the date hierarchy.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.