Forum Discussion
Dashboard dynamic filter
Howdy all, Have created a dashboard with a heap of KPI's on it. Most are monthly, and work easy - have column chart viz and the latest colum represents the current month. ALso on each KPI have the ...
amitchandak
Super User
Super UserNJCLIFFORD , You can use, relative date slicer, TOPN filter, TOPN measure.
You can use numeric parameters in TOPN
TOPN: https://youtu.be/QIVEFp-QiOk
TOPN with Numeric Parameter -https://youtu.be/cN8AO3_vmlY?t=26448
If that latest value of Date or time, we need measure
Like for date
new measure =
var _max = maxx(allselected(Date),Date[Date])
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] =_max))
for month MTD will show max month, based on the selection
MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))