Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Index column in calculated table

Hello, guys! Created dynamic date scales  https://www.inkeysolutions.com/blogs/power-bi-dynamic-scales-values/   and got the problem. The x-axis sorted in a wrong way   I created an "inde...
Need Help
sayaliredij's avatar
sayaliredij
Solution Sage
5 years ago

You can include Year + month as Index and sort accordingly 

 

eg. Jan 18  - 201801

      Feb 18  - 201802

 

Regards,

Sayali

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Yes, it works with numbers. But i need this month labels - Jan, Feb etc

  • sayaliredij's avatar
    sayaliredij
    Solution Sage
    5 years ago

    you can keep the column with the Month name, create an additional column index with not 1 or 2 numbers but 201801, 201802.. 

    you can sort month column using index column