Inline Load Sorting

[Karahs]

Hello All,

I have the following inline table:

Dim1:
Load * Inline
[
_Dim1No,Dim1
1,DateOfBusiness
2,Month
3,Week
4,City
];

I want the same order as above in my dimension (always selected one) on selection bar.

As above image i am not getting it order. Can anyone suggest any way to sort the inline load?

Thanks 

[tresesco]

Try loading using dual(), like:

Dim1:
Load 

_Dim1No,

Dual(Dim1, _Dim1No)  AS Dim1

Inline
[
_Dim1No,Dim1
1,DateOfBusiness
2,Month
3,Week
4,City
];

[Gysbert_Wassenaar · Accepted solution]

You can't get the same order in the selection bar. A filter pane has a Sorting section in its properties pane, but the selection bar cannot be changed. You could create a new field using the Dual function:

Dim1:
Load *, dual(Dim1,_Dim1No)as Dim2 Inline
[
_Dim1No,Dim1
1,DateOfBusiness
2,Month
3,Week
4,City
];

Dim2 will be a  numeric field with textual 'formats' for each number. Try it and see if it works for you.

[dhasharadh]

go to sorting options and uncheck A-> Z and check Load order.

[Karahs]

Thanks Gysbert_Wassenaar