Forum Discussion

jaryszek's avatar
jaryszek
Icon for Super User rankSuper User
1 year ago
Solved

Order for visual is not working

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

Need Help
  • Demert's avatar
    Demert
    1 year ago

    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. 

     

     

1 Reply

  • Demert's avatar
    Demert
    Icon for Resolver III rankResolver III
    1 year ago

    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.