Forum Discussion

davehardikkumar's avatar
davehardikkumar
Helper I
3 years ago
Solved

Hello Need help with week sorting

Hello, I have created below column and when I am adding it to slicer it is not giving me correct sorting order. how can I fix it? WeekEnding = VAR myWeekNum = WEEKNUM([Date]) VAR myYear = YEAR([Da...
  • eliasayyy's avatar
    eliasayyy
    3 years ago

    Press on your column where you have put the values for the slicer , you will find in column tools above something called sort column by , pressit and choose by weeksort column this should fix it

eliasayyy's avatar
eliasayyy
Memorable Member
3 years ago

To sort weeks create a week id

 

Weekid =

VAR  _y = Year(min('table'[Date]))

RETURN

WEEKNUM('table'[Date],2) + (YEAR('table'[Date]) - _min) *53

 

davehardikkumar's avatar
davehardikkumar
Helper I
3 years ago

I am using slicer and I am using weekending column from above post. how would your column help me to sort weekending column?

  • eliasayyy's avatar
    eliasayyy
    Memorable Member
    3 years ago

    Can you please show me a sample of th results?

    • davehardikkumar's avatar
      davehardikkumar
      Helper I
      3 years ago

      your soultion works fine. but what I want is I am trying to add different column on slicer and how can I sort it

      in above screenshot, weeksortid is your calculation which is working fine but and I want to sort it by Weekendingtest column in slicer. how can I achieve that?

      • eliasayyy's avatar
        eliasayyy
        Memorable Member
        3 years ago

        Press on your column where you have put the values for the slicer , you will find in column tools above something called sort column by , pressit and choose by weeksort column this should fix it