Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I have data coming from two different sources (SalesDataFY17Q3 and SalesDataCurrent) into a combined query (SalesData). One of the sources is data from last quarter (October, November December) and the other is the current quarter (Jan, Feb, Mar).
I have created a visual for trends of measures over time. All the data displays correctly but when I "Sort by month" it doesn't sort them in the correct order as seen in the screenshot below.
Any ideas?
Oops, can you see it now?
Hi @jakeryan56,
Have you tried the solution provided above? Does it work in your scenario? If you still have any question, feel free to post it here.
Regards
If you leave the data grouped as 'January' then you risk having the following data all being grouped into one bucket which is probably not what you are after.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
65 | |
63 | |
52 | |
37 | |
36 |
User | Count |
---|---|
79 | |
67 | |
60 | |
45 | |
45 |