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.
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.
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 |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |