I have tables -> calender , bi_alloceffort_data & bi_alloceffort_data_main. I Have linked calendar date column to REVDATE column of bi_alloceffort_data & "PROJECTNO" of both the tables.
I have created a timeline slicer from the calendar table.
I have two queries:
In slicer visual -> Format-> fiscal year, I selected April as the fiscal year. But the slicer shows 20-Oct-2019 as 2020 Q3 instead of 2019 Q3. Need to get it correct.
When user select a date range from the slicer, I need "ST_CLGBAL" -"ST_PREVCLGBAL" (from table bi_alloceffort_data) for the "JOBNO" where "REVDATE" lies in the user selected date range from the slicer.
pbix saved below