Sometimes, there is a situation in which we have to represent or filter our data based on the following parameters.
As we all know, Power BI provides some custom visuals in Power BI Gallery. One of the popular visuals for this type of filtering is “TimeLine Slicer.”
In this article, we will learn how we can configure this TimeLine Slicer with our Power BI Report.
Now, let’s get started!
First, we need to download that visual from a Power BI Custom Visual Gallery.
Here is a link for download custom Visual - URL
It will open the screen below.
Search for TimeLine Slicer.
It will open a description page of a visual. Click Add.
Download a Slicer.
It will download a slicer.
We will import this slicer in Power BI Desktop. To import, click on Import a custom visual.
Import from a File.
It will open a pop up > click Import.
Choose the downloaded Visual.
Our Visual is added successfully in the Power BI Desktop.
We have the following data for Sales.
Now, we have ordered data for the years 2009 to 2012
We have to filter our table based on,
For that, we will add Time Line Slicer.
Add a Time Line Slicer from a Visual. In Time column, select Order Date.
By default, it is showing monthly filter.
Now, let’s analyze TimeLine Slicer Visual. On the top of a visual, it is showing the option to select Time Line.
Y = Year
Q = Quarter
M = Month
D = Day
Let’s click on Year.
It will open a visual like this.
The year from 2009-2012 is displaying. Now, let’s click on the year 2010.
It will filter the data based on it.
Let’s click on Quarter. It will open a visual like this.
I want Q1 and Q2 data for 2010. We can drag a slider to select the Quarter.
Let’s click on Month. It will open a visual like this.
I want a data for January of 2010.
It will filter the data.
Let’s click on Week. It will open a visual like this.
I need January's first week data.
Let’s click on the Day. It will open a visual like this.
I need the data for March 1 2009. I will click on it so that the data is filtered.
There are various options for formatting. We can apply formatting using the below screenshot.
We can change the color of cells as well and many more.
This is how we can apply granular filter using TimeLine Slicer in Power BI.