Month sort for multiple years data

[Anonymous]

Hello,

I have a requirement where I need to create a visualization by month in calendarized order   ( Jan, Feb, Mar etc) and grouped by year ( 2016, 2017). 

This seems simple to me in the begining but I could not make it work. I have attached the data, requirement and my Power BI visualization screen-prints. Any help will be appreciated.

Thanks,

Lakshay

[Anonymous]

---

wrote:

Hello,

I have a requirement where I need to create a visualization by month in calendarized order   ( Jan, Feb, Mar etc) and grouped by year ( 2016, 2017). 

This seems simple to me in the begining but I could not make it work. I have attached the data, requirement and my Power BI visualization screen-prints. Any help will be appreciated.

Thanks,

Lakshay

---

---

wrote:

Hello,

I have a requirement where I need to create a visualization by month in calendarized order   ( Jan, Feb, Mar etc) and grouped by year ( 2016, 2017). 

This seems simple to me in the begining but I could not make it work. I have attached the data, requirement and my Power BI visualization screen-prints. Any help will be appreciated.

Thanks,

Lakshay

---

Hello,

Thanks for the quick reply. What you have shown is exactly what I am trying to achieve. Unfortunately, when I try to sort based on ID Month, it does not do anything.  I don't know where the problem is. Can you please help?

[GeraSanz11]

just check the months ids are numeric format and not text since it will sort differently also if that doesnt solves the problem, please add a screenshot of the database in edit mode so i can figure it out

[Anonymous]

The ID month column is numeric.  See below:

[GeraSanz11]

Then i recommend to re insert the graph sometimes it wont refresh 

first the grap, then the values followed by the Months names, and in the end the sort by

[Anonymous]

It worked like a magic 🙂

In the begining, I was adding all the measures in a table visualization was then adding the bar graph. It was not doing the sorting.

Now, I started with the bar graph and added the data. It came perfect,

May be this is a bug in Power BI desktop.

But I am really thankful for your time and effort. It worked for me in the end!

Thanks,

Lakshay

[v-chuncz-msft]

@Anonymous,

Glad to hear that. You may help accept the solution above. Your contribution is highly appreciated.

[GeraSanz11 · Accepted solution]

Hi! i don't get very well what you want or whats the problem, im guessing it's the month sorting in the first chart?

if that the case i recomend you adding a colun with a secuential from 1 to 12, something like the last 2 digits from the [Month YYYYMM] column

You will end up with something like this:

after that in the canvas just select the column month and then in the modeling tab select SortBy and chose the id_month just created as reference 

with this the months will be sorted by the ids or the number of the month instead of A-Z sort of the names

Hopes this helps