Sort by Day Month in the table ?

[suvechha]

Hi there,

I am unable to sort by Day Month in the table chart-

The sorting is only working when I brough the Month Number in the table, but the user don't want to see the Month Number column. Is there any way I can hide the the Month Number column ?

My Master calendar table look like below-

[amitchandak · Accepted solution]

@suvechha , Create a column like

Month Day = format([Date],"MMDD")

And mark it as the sort column of day month and then use day month in visual

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c