Forum Discussion

RJ's avatar
RJ
Resolver II
10 years ago
Solved

Sorting by Month as Text (Jan Feb Mar etc)

Hi   I can sort the slicer by month as shown on this thread. (its confusing but at least i can do this)   http://community.powerbi.com/t5/Desktop/Possible-Tip-Trick-Dynamic-Date-Dimension-Table/m...
  • RJ's avatar
    10 years ago

    OK got it

     

    https://support.powerbi.com/knowledgebase/articles/592116

     

    Go to data (left hand side button) and click

     

    Then go to the table to be sorted (right hand side)

     

    You will need three columns in this calendar table for month

    create

     

     

    1  Main column (to set up the link column for Invoice Date) 

       CalendarInv = CALENDAR (MINX(Header, Header[Invoice Date]), today())

    2  Column for month in text format

        MonthT = FORMAT( CalendarInv[Date], "MMM")

    3  Column for month in number format

        MonthN = Month (CalendarInv[Date])

     

    Grapph.GIF

     

    Then go to field list on the right hand side Click on MonthT

     

    Grapph.GIF

     

    then go to modelling / sort by column and select MonthN

    Grapph.GIF

     

     The final step is as follows

     

    Grapph.GIF

     

     

    NB Creating calendar table

    http://community.powerbi.com/t5/Desktop/Possible-Tip-Trick-Dynamic-Date-Dimension-Table/td-p/8462