Forum Discussion

wech747's avatar
wech747
Frequent Visitor
9 years ago
Solved

[Single number card] Create visual filter where year=current year

Hi,   i am struggling with creating a dynamic filter on a single number card, which I want to show the sum of a value of the current year. So far, I've just ticked the appriopriate year in the visu...
Need Help
  • wech747's avatar
    wech747
    9 years ago

    ...meanwhile I've got a solution for this case:

     

    I just created a measure and integrated the filter argument in there:

    sum of price in current year = CALCULATE(AVERAGE(Tabelle12[price]);Tabelle12[year]=YEAR(TODAY()))

     

    Thanks for your help anyway!

wech747's avatar
wech747
Frequent Visitor
9 years ago

Hi ceebu,

 

you are right, a screenshot might do a good job in this case:

 

I want to create a filter, which automatically selects the current year, instead of manually clicking it as shown in the screenshot.
Can you help me with that?