Forum Discussion
Reorder Axis
I got this graph:
It shows me all data of 2019,2020 en then for 2021 I see the data for each month.
I want the data in this order in my X-Axis:
2019, 2020, 2021, Jan, Feb, Mar, Apr, May, June, July, Aug,Sept, Oct, Nov, Dec
If I change my month format to 1,2,3 then my graph looks like this:
Can I sort on a column that is not in the visual, or can I add a dummy column to sort on in the graph ?
elbartje , You need to create a sort order column and mark that sort column
Example
Axis column 1 = [Axis Column]
Axis column sort = Switch(true(),
[Axis Column] = "2019", 1,
[Axis Column] = "2010", 2,
//Add others )
Mark Axis column sort as sort column for Axis column 1 and use Axis column 1 in visual
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
2 Replies
elbartje , You need to create a sort order column and mark that sort column
Example
Axis column 1 = [Axis Column]
Axis column sort = Switch(true(),
[Axis Column] = "2019", 1,
[Axis Column] = "2010", 2,
//Add others )
Mark Axis column sort as sort column for Axis column 1 and use Axis column 1 in visual
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-cThank you that did the trick !!
