Show Top 3 Years in Slicer

[bcap01]

Hello,

I want to create a Dashboard that dynamically shows the last 3 years by default.  I am new to PowerBI and assume if I create a slicer, I could then go into Visual Filters using the "Top N" filter type, but this does not seem to work.  Is there another, better method of doing this?  It seems I cannot Apply the TOp 3 as desired (see printscreen).

[v-yanjiang-msft · Accepted solution]

Hi @bcap01 ,

In the Top N filter, there is an option called By value.

You should still put the column in the field, then get the expected result.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Dinesh_Suranga]

@bcap01 

Hi,

Add new column to your date table. 

Top 3 Years = IF(YEAR([Date]) > YEAR( TODAY()) -3 , YEAR([Date]) ,0)

Then add new column to slicer and ignore 0 from filter.

Thank you.