I'm currently doing a new/end contract dashboard on a single page where there is two stack bar chart and one slicer, ideally I would prefer the if the user could select a month on the slicer and one of the chart could display the previous month end date data.
Sample data as below.
| Contract no | Start | End | Amount |
| 1 | 28/2/2021 | 31/3/2022 | $100 |
| 2 | 31/3/2021 | 1/4/2022 | $200 |
| 3 | 14/5/2021 | 15/4/2022 | $300 |
| 4 | 1/5/2022 | 30/4/2023 | $400 |
| 5 | 5/5/2022 | 4/5/2023 | $500 |
Eg. if user select 'May 2022' on the slicer, the bar chart will display:
1) New contract started in May 2022 - contract 4,5
2) End contract ended in Apr 2022 - contract 2,3
if user select 'Apr 2022' on the slicer, the bar chart will display:
1) New contract started in Apr 2022 - none
2) End contract ended in Mar 2022 - contract 1
is the example possible? and how do I create the contract end graph which show previous month ending contract?
