Forum Discussion
Sammy22
1 year agoHelper I
Periods parameter for user flexibility
Hello, I have a report which currently has set periods, P1 is 2023 and P2 is 2024. Users want to be able to change the date ranges of these periods, for example, they may want to look at the firs...
- 1 year ago
hello Sammy22
the best way is using filter pane as mentioned by lbendlin .
if you want tricky way, here is an example of what i did for my project.
1. create a duplicate table of your original table, something like this.
Table 2 = 'Table'
2. create P1 and P2 measure which P1 takes value from original table and P2 takes value from duplicated table.P1 =
IF(
ISFILTERED('Table'),
SUM('Table'[Orders])
)P2 =
IF(
ISFILTERED('Table 2'),
SUM('Table 2'[Orders])
)3. plot your slicer and measure. similarly as above, slicer 1 from original table and slicer 2 from duplicated table.Hope this will help.
Thank you.