Adding Timeline Slicers to PowerPivot Dashboards

PowerPivot has a couple of extra features that you can take advantage of while you are building your dashboards for slicing and filtering your data. One is called a Timeline Slicer.

NOTE: This is part of the Using PowerPivot to Analyze Your Dynamics AX Data blog series where we show how PowerPivot can assist you with advanced data analysis and reporting, making those extracts from Dynamics AX to Excel even more valuable. If you want to see all of the other posts in this series, click here.


To add a Timeline Slicer to your PowerPivot Dashboard, follow these steps:

  1. From the Analyze ribbon bar within Excel, click on the Insert Timeline from within the Filter group.
  2. When the Insert Timeline dialog box is displayed, any field that is formatted as a date will be available to be added as a Timeline slicer. Select one and then click on the OK button.


Now you can filter the data that is displayed by date range with the slicer.

1 comment

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: