Sort calculated column with Text data type

[NZ0090]

Hello everyone!

I want to create a slicer for days that will have a default value ("Current Day") and numbers 1-31.

I've created a calculated column like the image below:

The problem with this code is I can't set [DD_] column data type to Whole Number because otherwise the type won't match with "Current Day" (Text data type), but if I change [DD_] column type to Text data type, the Day slicer won't sort nicely (example in image below):

If you have any idea, advice or better ways to approach this issue, I'm all ears! Thanks in advance for your help.

[Arul · Accepted solution]

@NZ0090 ,

try to use Sort by column option, follow the below steps,
1. Select _CurrDay Slicer calculated column.

2. Then click Sort by column option from the Column tools menu.

3. Then sort the column using [DD_] column from the list. (this column data type should be in whole number)

Thanks,

Arul

[NZ0090]

That works! Thanks for your help