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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Vilas_Techie
Frequent Visitor

I want to be able to show past year values based on year selected in the slicer

Hi 

I have a dynamic slicer which: 

How can I write a DAX expression that show only the Sales of the last years based on the current selection of the year.
For Example:
-If I select 2015, the table should show only sales for the years 2015, 2014, 2013, 2012, 2011,2010
-If I select 2012, the table should show only sales for the years 2012, 2011 2010, 2009, 2008,2007

just want to note that I'm new to PowerBi so I really appreciate your help.

1 ACCEPTED SOLUTION
Gengar
Resolver I
Resolver I

Hi @Vilas_Techie ,

 

This is my data:

Gengar_2-1667831250496.png

 

You can create a new date table and use the data to create a slicer:

Gengar_0-1667831101475.png

Then create a measure as a filter:

 

Measure = IF(YEAR(MAX('Table'[Date]))<=YEAR(SELECTEDVALUE('Date'[Date])),1)
Gengar_1-1667831217290.png

 

 
 
Then it will work!
Gengar_3-1667831276507.png

View solution in original post

1 REPLY 1
Gengar
Resolver I
Resolver I

Hi @Vilas_Techie ,

 

This is my data:

Gengar_2-1667831250496.png

 

You can create a new date table and use the data to create a slicer:

Gengar_0-1667831101475.png

Then create a measure as a filter:

 

Measure = IF(YEAR(MAX('Table'[Date]))<=YEAR(SELECTEDVALUE('Date'[Date])),1)
Gengar_1-1667831217290.png

 

 
 
Then it will work!
Gengar_3-1667831276507.png

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.