Sorting the Column Name

[ADSL]

Hi BI Community Team,

I have created the new column name "time session" but after tried to build the visual and it didn't sort/range as the screenshot below.

Any suggestion to sort/rang it?

Thanks and Regards,

[olgad · Accepted solution]

Hi, create another column

Time Session_Index = SWITCH(TRUE(),

[Log_In] < TIME(8,0,0), 1,

[Log_In] < TIME(12,0,0), 2,

[Log_In] < TIME(13,30,0), 3,

[Log_In] < TIME(17,30,0), 4,

[Log_In] < TIME(21,0,0), 5, 6)

Then, click on the first column, go to column tools, select sort by column and sort by time_session_index

[ADSL]

Hi @olgad,

Thank you very much for your helpful feedback.

Best Regards,