Forum Discussion
[Single number card] Create visual filter where year=current year
...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!
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?
Advocate IYou should be able to use the TopN filter to select the values dynamically.
If your date column is formatted as date type, then you can select "Latest date" option to show current year.
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
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.