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?

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

If i understand you right, you want to be able to filter by the current year without manually selecting the year everytime it changes - Right ?

 

If yes, you should be able to use the TopN filtering method.

 

See this link : http://www.cloudfronts.com/power-bi-new-updates-date-slicer-top-n-filter-and-data-label-improvements/

 

Is your Date column formatted as Date type ? In that case you should be able to filter for the latest date - Which will give you current year.