Forum Discussion
Dynamically filtering a KPI visual by current financial year?
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
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"))
1 Reply
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"))