Forum Discussion
TopN sorting (Used in dynamic title)
I have used the dax formula written here for a dynamic title, based on the selection of a filter. In my case, I am using week numbers instead of days of the week, and have therefore amended the dax a...
v-jingzhang
Community Support
Community SupportHi Anonymous
The Title2 measure looks OK. Based on my test, it works well as below. I have attached my sample file at bottom.
In addition, what is the data type of "Week_No" column? I recommend that you change it to Whole number type. This will make it be sorted correctly.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Thank you for looking at this for me - I can confirm that week_no is already classified as Whole Number. This is how it's written, and the result I'm getting.
I have also tried
Week_No = VALUE(WEEKNUM(table[Invoice Date],2))
which makes no difference.