Forum Discussion
Sorting week is not working
VPonnarath,
Please update your formula to the following, then change data type of week sort column to whole number.Week Sort Column = CONCATENATE('Date'[Calendar Month Number],'Date'[Week Number of Month])
This way, when you sort Week Name-Month column by Week Sort Column, you will get expected sort.
Regards,
Lydia
ok so what is the issue. I guess you need to add more value in sort column but if you provide more details it will be helpful to resolve the issue.
thanks,
p
Okay. I will try to explain as I can.
I am trying to bring the week name ( ex: Jan-Week 1, Jan-Week2) in a line chart X axis.
I have date table with , Week number of Year, Week Number of Month columns . I created a calculated column for dispaying the week number in a more understandable way , ie.. Jan-Week1, Jan -week2 . Below is the dax I am using for this.
Week Name-Month = CONCATENATE('Date'[Fiscal Month],CONCATENATE("- Week",'Date'[Week Number of Month]))
I need to sort this cloumn like below
Jan-Week1
Jan-Week 2
...
...
..
Feb-Week1
Feb-Week 2
Uploading the pbix with date table here.. pbix
VPonnarath,
Please update your formula to the following, then change data type of week sort column to whole number.Week Sort Column = CONCATENATE('Date'[Calendar Month Number],'Date'[Week Number of Month])
This way, when you sort Week Name-Month column by Week Sort Column, you will get expected sort.
Regards,
Lydia