Hello All, I am having a data set with months and software usage for the each month. Once I plot it in PowerBI the months are taken in alphabetical order and not by Month. Can you please help me to...
cmaier
Advocate I
Advocate Iwithout seeing the data structurr its hard to know exactly the problem, but my first thought is that PBI doesn't know those are time series data. My first suggestion (and maybe you've done this) is to have a 'Date' table and have a month column in that table. If you want Month names I *think* Month=format('Date'[Date',"MMMM") should work (the exact notation might be wrong, but you get the idea. Then form a relationship between this month column and the month column in your original data. That might help with the sort issue. A second solution would be to alter your original Month column so it say "1-Jan", "2-Feb" etc. then sorting the axis should put them in numerical order.