Power BI - Date slicers

Hello friends and welcome to Tutorials Point

In this segment of the video, I'm going to show you how date slicer work in Power BI

So guys, you all must be knowing that the date element is the most important element at the time of business ysis

The reason being it helps me to do a future forecast in such a way that how I'm going to generate revenue in the upcoming years

and with the same element I can do the previous forecast as well so that

I can understand what have been performing so far. Alright guys so in power via desktop in date slicer we have four type of date

slices if I move on to the next slide you can see there are four type of

date slicer the first being is the between before after and list now what is

what are these four different kind of slicer will be having a better

understanding of this in our practical approach Hello friends and welcome in this video we are going to see how to use

date slicer in power BI in our previous video we have already seen how to use

normal slicer and get the result accordingly this time will be just focusing on

the date part and how to create date slicer in power BI so let's get

started off I will go under the visualization pane and simply select this

slicer visualization I get a blanks slicer out here I will simply take this

date section and drop it here the moment I drop it here do you see there is a

timeline that has been created starting from first of January 1999 and ending at

31st December 2015 that would be my last entry in this particular database all

right so this is what it is showing you the report for now it is giving me an

option where I can select a date range from which for which I want to see the revenue all right now if I go under this first Jan 1st January 1999 you see there is a box if you simply select this box or

click on this blocks block it will automatically give you a drop-down menu of

calendar from where I can either select which year I'd like to mention and what is

the date so let's say 10th of January 2002 to I would like to get the report for

15 let's say 15th of 17th of December 2015 all right so this is giving me the report accordingly I can either use this drop-down menu or

also I can use the slider with the help of which I can actually change the date

Would you like to see guys so if I select this Socle and if I drag it you can see the end date is automatically changing

We have the start date we have the end date if I want to search change the start date

I have to simply go on this particular circle and drag it so accordingly it is

is modifying the report and getting me the results accordingly so this is what a

between range looks like and this is nothing but my timeline all right now let's

go ahead and see what are the different options that I see out here so if I click

on this drop-down menu I can see as of now we are starting off with the between

range right now let's start with the before what does this before do so if I

simply select this you can see the start date is automatically grade out that

means I would like to get the report before the end date so I can mention the end date

what it should be and it fetches me the results accordingly and similarly my

projection changes do you see there is a slight change in the donut chart but you can see a significant change in the tree map itself all right guys so

this is what particularly this portion is changing a lot so this is how you can

use the before drop-down menu and if I select after now what see what happens

if I select after my end date is become stagnant that means I cannot change my end date but I can change my start date right so this is how the before after and between is working

alright so if I also go ahead and click on this drop-down menu I can see there are

so many other option list and drop-down we have already seen before how it

works and how it gives me the results now let's go ahead and see how the

relative drop-down menu is working all right so if I click on this relative

option you can see it is helping me to fetch a report relative to what now as you can see

there is a the text out here is very small so let's quickly go ahead and change the text I

need to go to the format button and under the format button I have a numeric inputs in

that I simply have to increase this last all right so let's go ahead and make it this

as 13 looks good all right now what it is showing you it is showing you the relative

report let's say I want to get the report of last three now it is giving you an option now what are the

option that we have it can give me last three days three weeks three weeks calendar

months months calendar years and years calendar so let's say I would like to get

the report for the last three years all right so the moment I select last three

years it is telling me it is starting from 24th of April and ending on 23rd of

April that is the last three years now you see if you see it is 2015 and it is

2018 so automatically it is giving me a particular date range right from this

particular drop-down menu I can select any category or any criteria which which

I wish to apply so this is as simple as to use the the the relative drop-down

menu all right now I will again go here and see what are the different things

or with an option so if I select list it is giving me list of all the date

range which does not look nice it better to have a drop menu as we can see it is occupying much less of a space and if I click on this drop menu I can actually select the particular year or the particular date which I would like to get the report for

Isn't that easy guys so this was one thing about it Also I would like to get you I would like to show you one more thing in this is that

I will create one more slicer out here I'll create one more slicer a blank slicer okay and in this particular slicer I'll drop the years now see what

what happens when I drop the years. So automatically I am getting the list of all the years and I can select a particular year and get the results accordingly

All right. Now this is what we can do in the normal slicer out here as well. But what I would like to share you specifically, let's say that I have a date range, right

Under the format tab, under the format tab, if I go to this general drop-down menu, do you see there is an orientation

If you click on this drop-down menu, I have two orientation that is vertical, which can be

seen right now now the moment I select horizontal see what happens the moment I

select horizontal I can get a timeline according to different years so let's

say that I would like to have the report for the year 2000 it will show me

the report for 2000 2000 and 2003 so I gets me the report of if I want to

select multiple items as we have already learned you have to use the control

key and select the multiple items and it is giving me the results accordingly

guys isn't that easy and great so in such a way that

If I select this horizontal menu, it is giving me an option in like a button, right

Simply with a single click of a button, I can get my dashboard

That is the region which we are working on. I can quickly customize my dashboard with the help of just a single click

So this is how the slicer or if I like to specify, this is how the date slicer works in PowerBi

All right, guys. So this was all for this video. See you until next time