Dynamically filtering a KPI visual by current financial year?

[Anonymous]

Hi, 

I am new to PowerBi. I am creating a CPD dashboard and I want to dynamically filter a KPI visualization by current financial year. This should be only for one visualisation. Also, I have a financial year column already in the dataset.

I have tried to create a measure to calculate current FY (which is working) however i am not sure how to use it to filter the visualisation.

Except this, I also want to show only last 4 years in a slicer. It would be great if someone can help me for these two things. Cheers

[amitchandak · Accepted solution]

@Anonymous , Try like

Measure =
var _max = var _max = maxx(allselected('Date'),'Date'[Date]) // OR// eomonth(Today(),0)
Var _maxFY = maxx(filter(allselected('Date'),'Date'[Date] = _max), 'Date'[FY])
return
calculate(sum(Table[value]), filter(date, Date[FY] =_maxFY))

You can also trywih FY end date

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"03/31"))