Forum Discussion
Two Period Slicers filtering data
Hi, I'm looking to create two slicers, where the user selects Start Period and End Period (see below): At the moment they're having to use a single slicer and multi-select the periods that...
You will need to use two disconnected dates table - on for period 1 and another for period2. Using a related table will show just what is selected. And then refererence those tables to filter an aggregation.
I'm using these measures below in the screenshot
Value within Periods =
CALCULATE (
[Sum of Value],
KEEPFILTERS (
DatesTable[Date] >= MIN ( Period1[Date] )
&& DatesTable[Date] <= MAX ( Period2[Date] )
)
)
Filter from Period1 =
--as visual filter for Period2, not blank
CALCULATE (
COUNTROWS ( Period2 ),
KEEPFILTERS ( Period2[Date] >= MIN ( Period1[Date] ) )
)
Refer to the attached pbix for the details.
Hi danextian , thank you for your response.
The periods come in the following format YY-YY:Period - 23-24:09 for example is Period 9 in the financial year 2023-2024. See below sample list:
Whereas yours is in Month-Year format. How do I do what you did for my requirements in terms of periods?
What month does your FY begin?
It begins in April but there are 13 periods in a financial year.
