Display last month end date from slicer

[EGRF]

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?

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[EGRF]

This has helped me greatly. Thanks for the solution!

[Ashish_Mathur]

You are welcome.