Forum Discussion

irongriffin007's avatar
irongriffin007
New Member
8 years ago
Solved

Date Priority

Hi everyone,   I'm having trouble getting Power BI to recognize the year of the date as requiring higher priority than the month.   Currently, when ordering dates from past to present, it will or...
  • parry2k's avatar
    parry2k
    8 years ago

    you need to add another column in your model to sort your month columns

     

    Add another columns like 

     

    Month Sort = FORMAT( DimDate[Date], "YYYY-MM")

     

    and in modellig tab chooise your month column and in sort by column from the menu choose, Month Sort columns which you just created.

     

    Let me know if you need further assistance.

  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    irongriffin007,

    Please follow the solution parry2k posted, you will get expected result as follows.

    Add a columnResult

    Best Regards,
    Angelia

parry2k's avatar
parry2k
Super User
8 years ago

you need to add another column in your model to sort your month columns

 

Add another columns like 

 

Month Sort = FORMAT( DimDate[Date], "YYYY-MM")

 

and in modellig tab chooise your month column and in sort by column from the menu choose, Month Sort columns which you just created.

 

Let me know if you need further assistance.