I'm facing an issue concerning the display of data in a chart, for the last 12 months.
I have 3 KPI to display : KPI Y, KPY Y-1 and KPY Y-2.
Each KPI has a fiscal/year period restriction :
My goal : Display the 3 KPI in a same chart, with the same X-axis (Posting Period / Week Number)
My issue :
My selected period is : 014.2015 to 013.2016
And my chart use posting period (1 to 52).
So in this case and in my chart, for my KPI Y, Posting period 1 to 13 represents data from 2016. Posting period 14 to 52 represents data from 2015.
So 2016 data are represented before 2015 data...
The need : Posting period 2015 display before 2016 (so X-Axis like 14 15 16.... 52 1 2 3 4.... 13)
I tried different solution (unsuccessfully), and we can't use Year dimension for this chart. If we use it, we will have data as 01.2014, 02.2014... 01?2015... 13.2016 and we won't have our 3 KPI in a same space, using the same posting period.
Thank all for your help.