Year = year([Date]) How to modify to show last 5 year ?

[admin11]

Hi All

May i know how to modify the below expression :-

Year = year([Date])

So that it will only show last 5 year.

[PhilipTreacy]

Hi @admin11 

Try this

Last 5 Years = FILTER(Year, YEAR(Date[Year]) >= 2018)

Regards

Phil

[admin11]

@PhilipTreacy 

https://www.dropbox.com/s/11dzrqm4g56zqys/PBT_V2021_333%20year%20display%202020%202021.pbix?dl=0

Above is my PBI file

Paul

[amitchandak]

@admin11 , you can create a measure. Or user slicer

Or create a column to filter 

FLag = if(year([Date]) >= year(Today()) -5, 1,0)

[admin11]

@amitchandak 

@PhilipTreacy 

Can you please share with me how to create expression for year , so when i use at Slicer , the Year filter will only display last 5 year.

Paul Yeo

[PhilipTreacy · Accepted solution]

@admin11 

Download your PBIX with solution

Hi Paul,

Actually there's a better way.

In the Slicer, use Date from the Date Table in the Field and set it to only display the Year.

Then in your Filters use TopN filtering and drag Date from the Date Table into the By Value area and select to show the Latest Date, then set the filter to show the Top 5.

Regards

Phil

[admin11]

@PhilipTreacy 

Now i start to understand that , need to make use of filter panel. thank you for sharing.

Paul

[admin11]

@amitchandak 

Your expression working fine. But i al looking for expression Year to display at every page user don't to tick 1 or 0. 

@PhilipTreacy  approach is correct , but got error.

https://www.dropbox.com/s/11dzrqm4g56zqys/PBT_V2021_333%20year%20display%202020%202021.pbix?dl=0