Forum Discussion
Two Period Slicers filtering data
It begins in April but there are 13 periods in a financial year.
How are the dates distributed accross periods then? Please provide a sample data or sample pbix.
Here's a sample data:
Not an image please.
Period No. Start Date End Date
Period 1 01/04/2023 29/04/2023
Period 2 30/04/2023 27/05/2023
Period 3 28/05/2023 24/06/2023
Period 4 25/06/2023 22/07/2023
Period 5 23/07/2023 19/08/2023
Period 6 20/08/2023 16/09/2023
Period 7 17/09/2023 14/10/2023
Period 8 15/10/2023 11/11/2023
Period 9 12/11/2023 09/12/2023
Period 10 10/12/2023 06/01/2024
Period 11 07/01/2024 03/02/2024
Period 12 04/02/2024 02/03/2024
Period 13 03/03/2024 31/03/2024
Period 1 01/04/2024 27/04/2024
Period 2 28/04/2024 25/05/2024
Period 3 26/05/2024 22/06/2024
Period 4 23/06/2024 20/07/2024
Period 5 21/07/2024 17/08/2024
Period 6 18/08/2024 14/09/2024
Period 7 15/09/2024 12/10/2024
Period 8 13/10/2024 09/11/2024
Period 9 10/11/2024 07/12/2024
Period 10 08/12/2024 04/01/2025
Period 11 05/01/2025 01/02/2025
Period 12 02/02/2025 01/03/2025
Period 13 02/03/2025 31/03/2025