Forum Discussion

Sobek's avatar
Sobek
Regular Visitor
9 years ago
Solved

12 months running data

Newbe here. Hi. How to visualize the data by month in Power bi desktop with 12 months running data, in chronological  order? Say starting from June 2016 through May 2017? In Power Pivot it was easy...
Need Help
  • Sobek's avatar
    Sobek
    9 years ago

    Thanks for the response - I had tried sorting by MOnth but it didn't work the way I wanted.

    But you know what? Somehow I have solved my problem with using Date (bin) feature. I do not know anything about those bins, but I have to read about it.

     

    Anyway - thanks again. It is a great forum and great help - especially for beginners

     

    Take care

    Sobek

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi Sobek,

 

What you will need to do, is to create another column, which will have a Number associated to the Month. You can then use the Sort by Column option under Modeling tab to sort your Month Name by this column. :smileyhappy:


Here is a great blog post explaining how to achieve this: Sorting by Month Names in Power BI

 

Regards

Sobek's avatar
Sobek
Regular Visitor
9 years ago

Thanks for the response - I had tried sorting by MOnth but it didn't work the way I wanted.

But you know what? Somehow I have solved my problem with using Date (bin) feature. I do not know anything about those bins, but I have to read about it.

 

Anyway - thanks again. It is a great forum and great help - especially for beginners

 

Take care

Sobek

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    Hi Sobek,

     

    Great to hear the problem got resolved! Could you accept your reply above as solution to close this thread? :smileyhappy:

     

    Regards