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,

 

thank you very much for your answer.

 

Unfortunately column isn't formatted as date type, it hast just the data type 'number'.
When using the TopN filter as described, I unfortunately don't receive the correct numbers.

 

Is there any other possibility to solve this problem?

Kind regards

ceebu's avatar
ceebu
Icon for Advocate I rankAdvocate I
9 years ago

When formatted a numbers, do you see the option "Top" under "Show Items" ? You could probably try Top "1" and in the "ByValue" field, use the date column.