Forum Discussion
Month sort for multiple years data
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
The ID month column is numeric. See below:
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
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
Anonymous,
Glad to hear that. You may help accept the solution above. Your contribution is highly appreciated.