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...
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_SeamarkMicrosoft Employee
Microsoft EmployeeIf 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