Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.