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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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