topic Re: Reorder Axis in DAX Commands and Tips

Reorder Axis

elbartje — Mon, 27 Dec 2021 08:30:54 GMT

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 ?

Re: Reorder Axis

amitchandak — Mon, 27 Dec 2021 08:36:05 GMT

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

Re: Reorder Axis

elbartje — Mon, 27 Dec 2021 09:34:27 GMT

Thank you that did the trick !!