Year long revenue line chart simultaneously with a specific month sliced the matrix visual

[JuanBolas]

Hello

I'm a newbie and am really stuck.

I'm displaying an income statement sliced by two months using the chiclet slicer. 

On the same page I need to display a line chart of the actual revenue (line "Ingresos Brutos" which is the result of a running total measure) and the budgeted revenue (line "Facturacion" based on data from the 'Budget' table) for the last 12 months counting from the last date of data in the 'Actual' table data.   Following the same logic I need to display the net results ('Resultado Neto').

I can't get the chart up and running  

My PBIX is here: https://drive.google.com/file/d/1pThZIX9B0IpD-PNVngHB-B3xA48p8HRv/view?usp=sharing

Thanks in advance.

[JuanBolas]

Thank you @amitchandak!

[amitchandak · Accepted solution]

@JuanBolas , If you select one date and want a trend of more than 1 month, then you need slicer on independent date table

//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = eomonth(_max, -12) +1
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI