for example "As of Date" on the top filter bar to 07/01/2022, which filter the workbook to this date only, including the Termination analysis section which only have one day's data to analyze too, which we need Terminations of CURRENT YEAR against the "As of Date", which would be 2022.

sorry ... I had to poste sentence by sentence as above for some reason.

PERIODROLLING("HCM - Workforce Core"."Facts - Workforce Events"."Termination Count", -13, 1)

The below can calculate the past 12 month's termination count, but we want the termination count of the year of the AsOfDate parameter, do you have an idea how to do that? Wish we could pass dynamic formula instead of constant as "-13, 1" to this PERIODROLLING function?

still take the same example, "As of Date" on the top filter bar to past date of 07/01/2022, even though this visualization filter can pull Termination count/analysis against year 2022 accordingly, but only one day's data is available to the whole workbook and we actually want the termination count for year of 2022.

Thank you very much Gayathri for your help .... Now I can pass the selected value from Workbook Filter to Visualization filter through parameter. But realized only one day's data coming into workbook because of that Workbook AsOfDate Filter, then the below becomes the new issue now :-)

for example if I select AsOfDate = 01/01/2022 in Workbook filter, I want this selected data is be available in my Virilization filter of "Current Year", so that the current year is 2022 against "AsOfDate = 01/01/2022"

Thank you for quick response ... not really simply want a different year, we want the YEAR of the "As of Date" filter on the top filter bar(Workbook/Global variable?)

Say we have the "As of Date" on the top filter bar(Workbook/Global variable?), which is DATE instead of YEAR, we pin this filter to all the canvases in the workbook, this "As of Date" works great against our first 2 canvases to pull all different counts/analysis "As of Date", except on the third canvas which we we have…