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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
P0W3RB1
Helper I
Helper I

Timeline slicer - Limit Range

Hi

 

I have a timeline slicer, it goes all the way back to 2011 but im only intersted in last year and current year. Is there someway of limiting it? it uses a date field from a calendar table, i can see dates that go all the way back to 2011 but how can i exclude them?

 

Thanks

2 REPLIES 2
AlexChen
Employee
Employee

Hi,

 

For example, you have a table (called “myTable”) like below:

 

1.png

 

You can create a new table with data of this year and last year only :

 

newTable = FILTER(mytable, YEAR(mytable[date]) = Year(Today()) || YEAR(mytable[date]) = Year(Today()) - 1)

 

2.png

 

Now you can create a new slicer with “newTable[date]” and there is only year 2015 and year 2016.

 

3.png

 

Best Regards

Alex

 

 

 

bullius
Helper V
Helper V

Have you tried applying a page or report level filter?

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.