Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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?
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
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
98 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |