Forum Discussion
Date 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...
Hi
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?
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