Order for visual is not working

[jaryszek]

Hi Guys,

i have days from 1 to 30 in Dim_Date table sorted by Day column but this is not working here:

order is not kept.

I can sort visual like here:

but i want to use my custom sort, not ascendind/descenging. 

I went do Data tab and use Sort by column. 

How to keep custom sort order insrtead of ascendind or descending?

Best,
Jacek

[Demert · Accepted solution]

Hi @jaryszek , it seems like your day column (1-30) in your dim table is not an integer but a text. Because it's sorting the 1,10,11,12 first and then the 2,20,21,.... You can easily adjust it in your table view and select the day column and change it to whole number.