Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

KPI visual Current year filtering

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's avatar
    v-xiaotang
    3 years ago

    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.

1 Reply

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    3 years ago

    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.