KPI visual Current year filtering

[Anonymous]

Hello everyone,

I found a similar post on this topic but I wasnt able to implement it in my report.

I'd like for the KPi visua to display the performance of the current year.

Is there a way to put the simple measure for current year YEAR(TODAY()) into the filtering section of the visual?

Or do I have to calculate the value in a seperate measure with a filter regarding the current year?

My period coloumn holds full years (2021,2022,2023 etc.) only.

Thanks in advance!

[v-xiaotang · Accepted solution]

Hi @Anonymous 

>> Is there a way to put the simple measure for current year YEAR(TODAY()) into the filtering section of the visual?

create a measure and put it into visual-level filter and set it to 1       

Measure = 
var _selected=SELECTEDVALUE(slicer[Column1])
return SWITCH(TRUE(),
_selected="this year", IF(YEAR( MIN('Table'[Date]))=YEAR(TODAY()),1),
_selected="all",1)

result

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.