Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
deuneue98
New Member

filter an object so that it only displays that from the current year and prior

hello ppl, I have a question, I have been asked to filter an object so that it only displays thata from the current year and prior
I have tried to create a rule under the filter options so that year <= year(today()), but apparently you cant do this
as you can see here

 

xa1a.png

1 ACCEPTED SOLUTION
Rayizer
Memorable Member
Memorable Member

@deuneue98 
Have a look at this: https://hevodata.com/learn/power-bi-calendar-table/
It shows how to create a calendar table (if not already using one) and then how to create a RelativeYear column. Then you can filter with that. The filter column should return true/false based on the year.

View solution in original post

2 REPLIES 2
MahyarTF
Memorable Member
Memorable Member

Hi, 

You could create a measure/Column in your table that is shown the current year (as you mentioned 'year(today())'), then use that in your filter pane.

Appreciate for Kudos

Mahyartf
Rayizer
Memorable Member
Memorable Member

@deuneue98 
Have a look at this: https://hevodata.com/learn/power-bi-calendar-table/
It shows how to create a calendar table (if not already using one) and then how to create a RelativeYear column. Then you can filter with that. The filter column should return true/false based on the year.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors