Forum Discussion
jakeryan56
Advocate II
Advocate IIDate sort issue with visual
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 t...
jakeryan56Advocate II
Advocate IIOops, can you see it now?
Phil_Seamark
Microsoft Employee
Microsoft EmployeeHi
I suspect you need to add a year component. So change 'January' to 'January 17'. This includes the underlying column you may be using as a 'sort by column'.
Do you have a Calendar table in your model?
I suspect you need to add a year component. So change 'January' to 'January 17'. This includes the underlying column you may be using as a 'sort by column'.
Do you have a Calendar table in your model?
- Phil_Seamark
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.
- January 2015
- January 2016
- January 2017