Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

sorting on multiple years data

Hi All,   I've calendar which contains the mulitple years of infomation and i have liked this calendar to transaction table.   But i couldn't sort it by y year-month. Attached the screenshot for ...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

Create following for the month

 

 

sort month = format(date[date],"YYYYMM")

 

 

Then in Model view, mark this as sort column for the month-Year column. In graph sort using sort option under ... 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi, I am getting below error while sorting based on the sort column.

  • v-diye-msft's avatar
    v-diye-msft
    Community Support
    6 years ago

    Hi Anonymous 

     

    Please kindly share your simple worksheet/dummy pbix preferred.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi, I am able to fix the issue. Thanks