Slicer with Fiscal Year(June Year End) & Calendar Year Options

[isam2003]

Hello:

The dataset I am working on relates to a company with June year end.  Sales are available on a quarterly basis (Q1, Q2, Q3, Q4). 

Fiscal Year End June XX
2022	Q1	Jun-Sep 2021
2022	Q2	Oct-Dec 2021
2022	Q3	Jan-Mar 2022
2022	Q4	Apr-Jun  2022

I would like to provide an option in a slicer to toggle between fiscal year and calendar year annual comparisions (for eg. for calendar year 2022, the sum would include Q3 FY2022, Q4 FY2022, Q1 FY2023, Q2FY2023). 

Any guidance on how to accomplish this would be much appreciated. Thanks in advance. 

[Greg_Deckler · Accepted solution]

@isam2003 Too complicated to explain fully see attached PBIX file below signature. Involves 2 disconnected tables, a calculated column and a measure.