The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
Solved! Go to Solution.
@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.
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
@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.