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,

thanks for the advice. But unfortunately, in the available spreadsheet the "top" number isn't "2017", as there are also forecasts in there. So, the "Top N filter" doesn't fit in this case.

 

 

Hi Back2Basics,

thanks for your advice. You are right, there is this described option, but the thing is that I have to create 4 single number cards from totally different spredsheets without any relation. As a result I would have to create 1 "year"-slider for each number card - which isn't that beautiful in my opinion.

 


Isn't there any option to solve this use case in a more 'elegant' way?

wech747's avatar
wech747
Frequent Visitor
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!