Power BI Date Slicer [With 41 real examples]

Do you want to know about Power BI date slicer? Keep reading to know everything on date slicer in Microsoft Power BI with a few real examples.

  • Power BI Slicer
  • Power BI Date Slicer
  • Power BI how to add Date Slicer
  • Power BI Date Slicer as slider
  • Power BI Date Slicer as list
  • Power BI Date Slicer dropdown
  • Power BI Date Slicer month year
  • Power BI Date Slicer single date
  • Power BI Date Slicer by month
  • Power BI Date Slicer only shows dates with data
  • Power BI Date Slicer between two dates
  • Power BI Date Slicer default to today
  • Power BI Date Slicer between default value
  • Power BI Date Slicer date and time
  • Power BI Date Slicer for all pages
  • Power BI Date Slicer relative and between
  • Power BI Date Slicer by week
  • Power BI Date Slicer by quarter
  • Power BI Date Slicer current month
  • Power BI Date Slicer for multiple columns
  • Power BI get max date from the slicer
  • Power BI get Date range from Slicer
  • Power BI get generic date from slicer
  • Power BI date slicer greater than
  • Power BI Date Slicer horizontal
  • Power BI Date Slicer date hierarchy month
  • Power BI Date Slicer include blanks
  • Power BI Date Slicer last 30 days
  • Power BI Date Slicer last 12 months
  • Power BI Date Slicer last weeks
  • Power BI Date Slicer last 7days
  • Power BI Date Slicer week start monday
  • Power BI Date Slicer quarter
  • Power BI Date Slicer search
  • Power BI Date Slicer showing future date
  • Power BI date slicer default to Yesterday
  • Power BI Sort date slicer ascending
  • Power BI Slicer clear selection
  • Power BI Slicer Current date
  • Power bi multiple date slicer on one page
  • Power Bi relative date slicer
  • Power bi from to date slicer

Power BI Slicer

The Power BI Slicer is a visualization filter that we can add to the canvas. The slicer provides the feature to filter and sort the packed report and view the information you want. If you want to read more, check out, Power BI Slicer – How to use with examples

Power BI Date Slicer

The Power Date slicer filters information on visualization using the date data type. By default, a Power Bi slicer is equal to a numeric range slicer. However, if you want to filter the data based on a specific day, month, or year, you can also treat it as a category slicer.

Depending on your dataset, Power BI Date Slicer is well-featured to explicitly find connections between different date levels. You can filter the data based on a hierarchy of information such as year, quarter, month, and day.

Read Power BI split column

Power BI how to add Date Slicer

Here we will see how to add a date slicer in Power BI

We will use the Financial sample table data you can get the data from here.

To add the date slicer to the Canvas in Power BI, follow the below steps:

  • In Power BI Desktop, select the Slicer from the visualization pane.
  • The drag the Date field from the Field pane into the Field field.
  • Now you can see the date slicer, showing the range from the start date to end date present in the table.
Power BI how to add Date Slicer
Power BI how to add Date Slicer

This is how to add Date Slicer in Power BI.

Power BI Date Slicer as slider

Here, we will show the date slider in Power BI using the Slicer visual.

To create the Date slider using Slicer in Power BI, follow the below steps:

  • In Power BI, select the Slicer visual, from the visualization pane.
  • Then add the Date column to the FIeld in the Field section in the Visualization pane.
  • In the Slicer visual -> select the drop-down icon -> Between from the options.
Power BI Date Slicer as slider 1
Power BI Date Slicer as slider

Now you can see the Date slider in the Slicer in Microsoft Power BI.

Microsoft Power BI Date Slicer as slider
Microsoft Power BI Date Slicer as slider

This is Power BI Date Slicer as slider.

Read Power Query Date

Power BI Date Slicer as list

Here, we will show the date as a list in Slicer visual in Power BI.

To show the date as a List in Slicer visual in Power BI, follow the below steps.

  • In Power BI, select the Slicer visual from the visualization pane.
  • Then add the Date column to the FIeld in the Field section in the Visualization pane.
  • In the Slicer visual -> select the drop-down icon -> Lists from the options.
Power BI Date Slicer as list
Power BI Date Slicer as list

Now, you can see the Lists of dates in Slicer, by selecting them you can filter the visual.

Microsoft Power BI Date Slicer as list
Microsoft Power BI Date Slicer as list

This is Power BI Date Slicer as a list

Power BI Date Slicer dropdown

Here, we will show the dates as a dropdown in Slicer using Power BI.

To show the dates as a dropdown in Slicer in Power BI, follow the below steps:

  • In Power BI, select the Slicer visual from the visualization pane.
  • Then add the Date column to the FIeld in the Field section in the Visualization pane.
  • In the Slicer visual -> select the drop-down icon -> Dropdown from the options.
Power BI Date Slicer drop down
Power BI Date Slicer dropdown

Now click on the down arrow to see the list of dates, by selecting them you can filter the visual.

Microsoft Power BI Date Slicer drop down
Microsoft Power BI Date Slicer dropdown

This is how Power BI Date Slicer dropdown.

Read Power Query Examples

Power BI Date Slicer month year

Here, we will show the month and year from the date in the Slicer in Power BI. For this example, we will use the Financial table.

To display the Month Year in Date Slicer using Power BI, follow the below steps:

  • In Power BI, select the slicer visual from the visualization pane.
  • Then drag the date column, in the Field. Then click on the drop-down arrow -> select Date hierarchy.
Power BI Date Slicer month year
Power BI Date Slicer month year
  • Next, delete Quarter and day by clicking on the cross icon. Then expand the year option so you can see the months. Here we have expanded the 2014 year and you can see the months.
Date Slicer month year in Power BI
Date Slicer month year in Power BI

This is how Power BI Date Slicer month year.

Read Create table using Power Query in Power BI

Power BI Date Slicer single date

Here we will see how to create a single date picker slicer in Power BI.

With the help of the filter pane, we can easily select a single date and filter the visuals. Sometimes users don’t have access to the filter pane, so we need to create a slicer on the page so that users can easily filter the data.

To create a single Date picker slicer in Power BI, follow the below steps:

  • In Power BI select the Slicer visual from the visualization pane.
  • Then drag the Date field into the Field section in the Visualization pane.
  • Select the slicer visual, click on the drop-down arrow -> select After from the list, which will allow you to select a single date.
Power BI Date Slicer single date
Power BI Date Slicer single date
  • Then go to the Formatting section in the Visualization pane
    • Turn off the Slider and Slider header
    • Then turn on the Title section and expand the Title section and under the Title text provide ‘Select a date’.
Date Slicer single date in Power BI
Date Slicer single date in Power BI

Now you can only select a single date, but it will filter the data based on the selected date and the dates are available after the selected date. Here I have selected the date of 1/06/2014, so it will the data present in the table visual ( date and Sales columns) is based on the date 1/06/2014 and after the available date.

Date Slicer single date in Microsoft Power BI
Date Slicer single date in Microsoft Power BI

In the table visual in the above screenshot, you can see the total sales are based on date, as well it adds the date after the selected date. If you want to get the total sales for the Selected date, then we need to create a measure that will filter the selected date’s total sales.

So create a Measure by clicking on New measure from the ribbon, then in the Formula box add the below Measure:

Selected date total sales = var SelectedDate= MIN(financials[Date])
return
CALCULATE(SUM(financials[ Sales]),TREATAS({SelectedDate},financials[Date]))

Now add the measure to the Table visual instead of the Sales field, and you can see the total sales for the selected date.

 In Microsoft Power BI Date Slicer single date
In Microsoft Power BI Date Slicer single date

This is an example of Power BI Date Slicer single date.

Read Power BI if date

Power BI Date Slicer by month

Here we will see an example of a Power BI date slicer by month. It is required to use a filter based on month year, and if users like to see the latest month information as the default view. Let’s see how to filter the latest month’s data using slicer using Power BI, follow the below steps:

  • In Power Bi Create a new column for the Month year, so click on the New column -> provide the formula to the Formula box.
Month Year = FORMAT(financials[Date],"MMM-YYYY")
  • Next, create another custom column, so click on the New column and then provide the formula in the Formula box.
YYYYMM = FORMAT(financials[Date],"YYYYMM")

Now we will create a column that will identify the latest month and past month from the date column. So create a custom column by clicking on the New column from the ribbon. Then in the Formula bar, write the below formula.

Latest Month = IF(MONTH(financials[Date]) = MONTH(MAX(financials[Date])) && YEAR(financials[Date]) = YEAR(MAX(financials[Date])), "Latest Month", "Past Months")
  • Now select the Table visual, from the visualization pane, then drag the Date, Month Year, YYYYMM, Latest Month, and Sales columns from the Field pane into the Values field.
Power BI Date Slicer by month
Power BI Date Slicer by month
  • Next, we will create a hierarchy slicer, so select the slicer from the visualization pane. Then drag the Latest month and Month Year column from the field pane in Fields in Field selection in the Visualization pane.
  • Next click on the Latest month and you can Latest date present in the Table, get filter the table visual.
Microsoft Power BI Date Slicer by month
Microsoft Power BI Date Slicer by month

This is an example of Power BI Date Slicer by month.

Read Power BI IF + 31 Examples

Power BI Date Slicer only shows dates with data

Here we will see how to use the Date slicer which will only show dates with data in Power BI.

To only shows dates with data in Power BI Date slicer. For example, we will create a date slicer with dates and also data like sales and profit. So it will show dates with data in hierarchical order.

  • In Power BI Desktop, select the slicer from the visualization pane.
  • Then drag and drop the Date, Sales, and Profit into Field from the field pane.
  • Next, in Slicer expand a date by clicking on the down arrow, and you can see the sales data based on that date, next expand the sales section you can see the profit data.
Power BI Date Slicer only shows dates with data
Power BI Date Slicer only shows dates with data

Now I have a table visual with date, product, sales, and profit data, so click on the 09/01/2021 in the slicer, based on the date table visual get filter.

Microsoft Power BI Date Slicer only shows dates with data
Microsoft Power BI Date Slicer only shows dates with data

This is an example of Power BI Date Slicer only shows dates with data.

Power BI Date Slicer between two dates

Here we will see an example of a Power BI Date slicer between two dates.

In Power Bi Date Slicer between options provides the user a date range between the start date and end date with a horizontal scroll bar.

  • In Power BI Desktop, select a Slicer from the Visualization pane.
  • Then drag and drop the Date field from the Field pane into the Field.
  • Then click on the down arrow in the Slicer visual and select the Between option.
Power BI Date Slicer between two dates
Power BI Date Slicer between two dates
  • Now if we will set the date based on the start date or end date, the data get filter like the below screenshot.
Microsoft Power BI Date Slicer between two dates
Microsoft Power BI Date Slicer between two dates

This is an example of Power BI Date Slicer between two dates.

Read Power BI Pie Chart

Power BI Date Slicer default to today

Here we will see how to set Date slicer default to today in Power BI.

To set today’s date as default in the Power BI Date slicer, we need to create a calculated column, if the date is equal to today’s date then it will identify as Today and it gets updated dynamically.

  • In Power BI Desktop, create a new calculated column with the below formula:
Today's date = IF(Sheet1[Date]= TODAY(),"Today", IF(Sheet1[Date] >TODAY(),[Date]&"",IF(Sheet1[Date]<TODAY(),[Date]&"")))
  • Now, select the slicer visual from the visualization pane. Then drag and drop the Today’s date calculated column into Field in the Visualization pane.
  • Next click on the More icon(…) -> Sort axis -> Sort descending order.
Power BI Date Slicer default to today
Power BI Date Slicer default to today
  • Now you can see the Today’s date at the top of the slicer and it dynamically updates.
Microsoft Power BI Date Slicer default to today
Microsoft Power BI Date Slicer default to today

This is an example of Power BI Date Slicer default to today.

Read Power BI Switch – DAX function

Power BI Date Slicer between the default value

Here we will see an example of Power BI Date Slicer between default values in Power BI.

To set the between option date slicer as the default value in Power BI. In this example, we will set the default date value for 7 days.

  • In Power BI, select the Slicer visual from the visualization pane.
  • Then drag and drop the Date field from the Field pane into the Field present in the visualization pane.
  • If in the Slicer visual are listed -> then click on the down arrow and select the Between option.
Power BI Date Slicer between default value
Power BI Date Slicer between default value
  • Next, expand the Filter pane, then in Filter on this visual section -> Expand the Date section by clicking on down arrow -> select the Filter type as Relative Date -> under Show items when the value, set is in the last, 7, days. Then check the box next to the Include Today, and click on Apply Filter.
  • You can see the default date for 7 days, and it gets updated dynamically.
Microsoft Power BI Date Slicer between default value
Microsoft Power BI Date Slicer between default value

This is an example of Power BI Date Slicer between default value.

Read Power BI Card

Power BI Date Slicer date and time

Here we will see how to add the date and time in the slicer in Power BI.

While using time in a slicer, you can only use the List or dropdown option. So follow the below steps to add the date and time in Slicer in Power BI.

  • In Power BI, select the slicer from the visualization pane.
  • Then drag the Date and Time column from the Field pane into the Fields.
  • In The slicer Expand the date, and you can see the time.
Power BI Date Slicer date and time
Power BI Date Slicer date and time

This is an example of Power BI Date Slicer date and time.

Power BI Date Slicer for all pages

Here we will see how to apply the date slicer for all pages in the report in Power BI Desktop.

To apply the date slicer filter for all pages we will use the Sync slicer feature. With this feature, a slicer selection on any page will affect the visualization on all selected pages in the Power BI report.

Let’s see how to create a Date slicer for all pages using the Sync slicer feature in Power BI Desktop.

  • We will apply the slicer on 2 pages, i.e. Page 2 and Page 3, for this we will create a date slicer on both the pages. To create a Date Slicer, select the Slicer from the visualization pane, the drag and drop the Date column from the field pane into fields.
Power BI Date Slicer for all pages
Power BI Date Slicer for all pages
  • Next, select the Slicer on Page 2, go to the View tab, and select the Sync slicers, which will open the Sync slicer pane.
  • Next in the Sync slicer pane, check the box for sync for Page 1 and Page 2, and then check the box for page 1, page 2, and page 3 under the eye icon.
Microsoft Power BI Date Slicer for all pages
Microsoft Power BI Date Slicer for all pages
  • Now you can use the date slicer to filter the pages, for example here we will filter the data for 1 month, i.e., 1/9/2021 to 30/9/2021 on page 2 and it will automatically filter the data by using the Page 3 slicer.
Date Slicer for all pages in Microsoft Power BI
Date Slicer for all pages in Microsoft Power BI

This is an example of Power BI Date Slicer for all pages.

Read Power BI Measure Sum and Subtract Example

Power BI Date Slicer relative and between

Here we will see the Power BI Date slicer relative and between.

We can switch the type of date slicer from the drop-down menu. We can choose options such as Between, After, Before, List, Relative, and Dropdown. So in this topic, we will discuss the Relative and Between types of Date slicers in Power BI.

Relative Date Slicer

This type of Slicer provides you the ability to filter the visual based on the relative date to Today’s date.

For example, we will filter the visual based on the last 7 days including today using Date Slicer in Power BI Desktop.

  • In Power BI Desktop select the Slicer from the visualization pane with the date column.
  • In the Slicer, click on the dropdown in the Slicer header -> select the Relative date from the dropdown
Power BI Date Slicer relative and between
Power BI Date Slicer relative and between
  • Then set the Relative date slicer, select Last, 1, and then select Month from the dropdown. You can see the visual get filtered based on the relative date slicer.
Microsoft Power BI Date Slicer relative and between
Microsoft Power BI Date Slicer relative and between

Between Date Slicer

This type of slicer provides the date range between the start date and end date with a horizontal scroll bar. We can filter the visual based on the start date or end date by scrolling the bar. This slicer is default date slicer, which means when we create a date slicer, Power Bi by default takes Between type.

For example, we will filter the visual based on 09/01/2021 to 09/07/2021 using Between Date Slicer in Power BI.

  • In Power BI Create a Slicer with the Date column, by default it will create between date slicer. If you have already created the Date slicer having other types, and you want to change to between, select the dropdown arrow in the Slicer header -> select the Between.
Microsoft Power BI Date Slicer relative and between type
Microsoft Power BI Date Slicer relative and between type
  • Now you can slide the horizontal scroll bar to filter the data like below.
Date Slicer relative and between in Microsoft Power BI
Date Slicer relative and between in Microsoft Power BI

This is an example of Power BI Date Slicer relative and between.

Read Remove blank from Power bi slicer

Power BI Date Slicer by week

Here we will see how to create Date Slicer by week in Power BI Desktop.

To create a Date slicer by week, which contains Week start date to Weekend date (Start date -End date). So when we select the slicer based on the number of weeks, the information gets filtered by the selected weeks. For this, we will create a calculated column in which we will store the Week range,

Let’s see how to achieve Power Bi date slicer by week:

  • In Power BI, create a new Calculated column, to get the Weeknum by using the below formula:
weeknum = WEEKNUM(Sheet1[Date],2)
  • Then create another calculated column, to calculate another Week range, by using the below formula:
Slicer = 
var _start_date = CALCULATE(MIN(Sheet1[Date]),FILTER(Sheet1,Sheet1[weeknum]=EARLIER(Sheet1[weeknum])))
var _end_date = CALCULATE(MAX(Sheet1[Date]),FILTER(Sheet1,Sheet1[weeknum]=EARLIER(Sheet1[weeknum])))
return
_start_date &" - "& _end_date
  • Now select the slicer from the visualization pane, then drag the Slicer(Calculated column) from the Field pane into the Field in the Visualization pane.
  • Now you can see the List of week ranges, and you can select any of the week ranges to filter the information.
Power BI Date Slicer by week
Power BI Date Slicer by week

This is an example of Power BI Date Slicer by week.

Power BI Date Slicer by quarter

Here we will see how to create a date slicer by a quarter in Power BI.

Let’s see how to create a date slicer based on quarter name, when we select Querted the information gets filtered.

  • For this create a Calculated new column, that will calculate the Quarter name by using the below formula.
QuarterName = Sheet1[Date].[Quarter]
  • Now select the Slicer from the visualization pane, then drag the Quarter name column from the field pane.
  • Now you can select any quarter to filter the information.
Power BI Date Slicer by quarter
Power BI Date Slicer by quarter

This is an example of Power BI Date Slicer by quarter.

Read Power BI Visualizations

Power BI Date Slicer current month

Here we will see how to filter data based on the current month using Power Bi Date Slicer.

To create a date slicer based on the two categories, History month data, and Current month data.

  • For this create a new calculated column, to categorize current month data and previous month data, by using the below formula.
LatestMonth = IF(FORMAT(MAX(Sheet1[Date]),"YYYY-MM")=FORMAT(Sheet1[Date],"YYYY-MM"),"Latest Month Data","History Data")
  • Next, select the slicer from the visualization pane, then drag the Latest month column from the field pane to the Field in the Visualization pane.
  • Then in the Slicer, select the Latest month, it will filter the information on the page in Power BI.
Power BI Date Slicer by current month
Power BI Date Slicer by current month

This is an example of Power BI Date Slicer current month.

Power BI Date Slicer for multiple columns

Here we will see how to create a single slicer to filter for multiple columns using Power BI.

So here we will create a hierarchical date slicer that will filter the multiple columns present in the table visual.

  • In Power BI Desktop, select the slicer from the visualization pane.
  • Then drag the Date column from the Field pane into Field in the Visualization pane.
  • Now, click on the drop-down and select the Date hierarchy
Power BI Date Slicer for multiple columns
Power BI Date Slicer for multiple columns
  • Now you can slice the information based on a specific year, quarter, month, and day. For example, we will filter the data based on 09/02/2021.
Microsoft Power BI Date Slicer for multiple columns
Microsoft Power BI Date Slicer for multiple columns

This is an example of Power BI Date Slicer for multiple columns.

Read Add Title, Image, and Video to Power BI Dashboard

Power BI gets the max date from the slicer

Here we will see how to get the dynamic Max date selection from the Slicer in Power BI.

To calculate the Max date, first, we will create a column to get the Max date. Then we will create another calculated column for the date slicer, that will dynamically get the Max date if the table gets updated in Power BI Desktop.

  • In Power BI Desktop, create a calculated column, to get the Max date by using the below formula.
Max Date = MAX(Sheet1[Date])
  • Then create another calculated column, for the dynamic date slicer by using the below formula. If the Max date gets updated, dynamically change in the slicer.
Date Slicer = IF(Sheet1[Date] = Sheet1[Max Date], "Max Date", Sheet1[Date]& "")
  • Now select the slicer from the Visualization pane, then drag the Date Slicer column from the field pane to the Field in the visualization pane.
  • Then sort the Date slicer in Descending order, now you can see the Max date.
Power BI get max date from slicer
Power BI get max date from slicer

Now you can see the Max Date in the Date slicer in Power BI. Based on Max date you can filter the information.

Microsft Power BI get max date from slicer
Microsft Power BI get max date from slicer

This is an example of Power BI get max date from slicer.

Power BI gets a Date range from Slicer

Here we will see how to get the date range from Slicer using Power BI.

For example, we will the below sample data, have a list of the task, but a task is assigned from May 10 to May 18, but if we want to check from May 12 to May 14.

Power BI get Date range from Slicer
Power BI gets Date range from Slicer

For this, we need to create a date slicer that can be only put one column at the same time. To work around it, you can create another calendar table, then drag the date column from this calendar table to a slicer visual. 

  • Firstly, we will create a calculated table for the date slicer, by using the below formula:
Slicer = CALENDAR(DATE(2022,01,01),DATE(2022,05,15))
  • Now in the Task table create a measure that will show the value when the Minimum date is selected from the Date Slicer by using the below formula.
MinSelectedDate = 
VAR minselected =
    CALCULATE (
        Min ( 'Slicer'[Date] )
        
    )
RETURN
    IF ( ISFILTERED ( 'Slicer'[Date] ), minselected )
  • Now in the Task table create a measure that will show the value when the Maximum date is selected from the Date Slicer by using the below formula.
MaxSelectedDate = 
VAR maxselected =
    CALCULATE (
        MAX ( Slicer[Date] )
        
    )
RETURN
    IF ( ISFILTERED ( Slicer[Date] ), maxselected )
  • Now we will create another measure that will calculate if we will select the date range, it will come under the assigned task then it will return 1 else blank, by using the below formula:
Measure = IF(Max('Table'[Start Date ])>=[MinSelectedDate] && MAX('Table'[End Date])<=[MaxSelectedDate] && MAX('Table'[End Date])<>BLANK(),1,BLANK())
  • Once we have done the calculation part, it’s time to implement. First, select the Slicer from the visualization pane, then drag the date column from the Slicer table.
  • Next create a Table visual with, Group, Start date, End date, Task columns, and Measure. Then select card visuals for min Selected date and Max selected date.
  • According to the Date range set in the Slicer visual, the information gets filtered.
Microsoft Power BI get Date range from Slicer
Microsoft Power BI get Date range from Slicer

This is an example of Power BI get Date range from Slicer.

Read PowerBI Report Filter using Slicer Visualization

Power BI gets a generic date from the slicer

Here we will see how to create a generic date slicer using two dates in Power BI.

For example, we will use the below table to have the start date and end date, within a particular date range set by the user. Each task in the table has the start date and end date.

So we want to select a custom range date, so that in one card visual we will show the number of tasks completed is filtered to count only tasks with an end date, within a custom range of date set.

And in another card visual, we will show, that the number of tasks started is filtered to count only the number of tasks with a start date, within a custom range of date set.

Power BI get generic date from slicer
Power BI gets a generic date from slicer

For this, we will create a date table that has a relationship with the start date and end date present in the below table. So we will create both the relationship as inactive, and we will be forced to explicitly specify which relationship to use in your DAX measure.

  • First, we will create a Date table by creating a New calculated table and by writing the below formula:
Slicer Date = CALENDAR(DATE(2022,01,01),DATE(2022,05,15))
  • Next, we will create two new measures, that will count the number of tasks ended and started based on the date range selected.
Task Completed = CALCULATE ( COUNTROWS ('Table'), USERELATIONSHIP ( 'Table'[End Date], 'SLicer Date'[Date] ) )
Task Started = CALCULATE ( COUNTROWS ( 'Table' ), USERELATIONSHIP ( 'Table'[Start Date ], 'SLicer Date'[Date] ) )
  • Now, select the slicer from the visualization pane, then add the date column from the Slicer Date table in the Field pane.
  • Next, create the two-card visual and drag and drop the Task completes measure and task started measure from the field pane.
  • You can filter the information based on the required date range. In this case, we have filtered the data i.e. task started and task completed from 1/1/2022 to 3/10/2022.
Microsoft Power BI get generic date from slicer
Microsoft Power BI gets the generic date from a slicer

This is an example of Power BI get generic date from slicer.

Power BI date slicer greater than

Here we will how to display data is greater than the date selected in the Date slicer in Power BI.

For example, we will use the date column in the slicer from the Financial 2021-2022 table. To get the greater dates than the selected date, for this we will use the After type date slicer.

  • In Power BI, select the Slicer from the Visualization pane.
  • Then, drag and drop the date column from the Field pane into the Field in the visualization pane.
  • Then in the slicer click on the down arrow in the slicer header -> choose After type from the options.
Power BI date slicer greater than
Power BI date slicer greater than
  • Now you can set the range, in the date slicer, it will show the date, after the first date. In this case, we will see the date greater than 10/24/2021.
Microsoft Power BI date slicer greater than
Microsoft Power BI date slicer greater than

This is an example of Power BI date slicer greater than.

Read How to Create Power bi report from SharePoint Online list

Power BI Date Slicer horizontal

Here we will how to create a horizontal date slicer in Power BI.

For example, we have the below slicer and the date range is listed vertically.

Power BI Date Slicer horizontal
Power BI Date Slicer horizontal

To change the orientation of the Date slicer horizontally, select the slicer visual -> then select the Format pane in the visualization pane -> expand the General section -> then in Orientation select the Horizontal.

Microsoft Power BI Date Slicer horizontal
Microsoft Power BI Date Slicer horizontal

This is an example of Power BI Date Slicer horizontal.

Power BI Date Slicer date hierarchy month

Here we will see how to create a date hierarchy in the Date slicer in Power BI.

For example, in the Financial data table, the date is from September 2021 to May 2022, so when we create a hierarchical date slicer with year and month. When we choose 2021, the date slicer is showing all the months of the year, Jan to Dec. Instead of showing September to December for 2021.

The reason behind showing all the months of the year is using a built-in date hierarchy in the slicer. For this, we can create custom columns for month and year, then drag them into the slicer.

  • In Power Bi create two calculated columns, for year and month by using the below formula.
Year = YEAR(Sheet1[Date])
Month = MONTH(Sheet1[Date])
  • Now select the slicer from the visualization pane, drag and drop the Year and month column from the Field pane into the Field in the Visualization pane, which you can see on the right side. And in the left side, you can see the Built-in date hierarchy in the Power BI Slicer.
Power BI Date Slicer date hierarchy month
Power BI Date Slicer date hierarchy month

This is an example of Power BI Date Slicer date hierarchy month.

Read Access to the resource is forbidden error in Power BI

Power BI Date Slicer includes blanks

Here we will see an example of Date Slicer includes banks in Power BI.

For example, we will use the End date column in the slicer from the below table.

Power BI Date Slicer include blanks
Power BI Date Slicer includes blanks

In Power BI, if we are using between type in date slicer, then it always needs the start date and end date. Within that start date and end date, any blank values present will show you in the visuals.

  • In Power BI select the slicer visual from the visualization pane, and then add the end date to the slicer.
  • Now filter the visual based on the date range like below:
Date Slicer include blanks in Power BI
Date Slicer includes blanks in Power BI

This is an example of Power BI Date Slicer include blanks

Power BI Date Slicer last 30 days

Here we will see how to set 30 days in the Date slicer in Power BI Desktop.

For this example, Relative date type in the Date slicer to get the last 30 days in Power BI Desktop.

  • In Power BI Select the Slicer visual with the Date data.
  • Then in the Slicer visual-> select the down arrow -> select the Relative Date type.
  • Then select Last, 30, and select days from the option.
Power BI Date Slicer last 30 days
Power BI Date Slicer last 30 days

This is an example of Power BI Date Slicer last 30 days.

Read Create a Power BI report from Excel using Power BI Desktop

Power BI Date Slicer last 12 months

Here we will see how to set the last 12 months in the Power BI Date slicer.

For this example, we will use the Relative date type in the Date slicer to get the last 12 months in Power BI Desktop.

  • In Power BI Select the Slicer visual with the Date data.
  • Then in the Slicer visual-> select the down arrow -> select the Relative Date type.
  • Then select Last,12, and select Months from the option.
Power BI Date Slicer last 12 months
Power BI Date Slicer last 12 months

This is an example of Power BI Date Slicer last 12 months.

Power BI Date Slicer last weeks

Here we will see how to set the date slicer for the last 2 weeks using Power BI.

For this example, we will use the Relative date type in the Date slicer to get the last 2 weeks in Power BI Desktop.

  • In Power BI Select the Slicer visual with the Date data.
  • Then in the Slicer visual-> select the down arrow -> select the Relative Date type.
  • Then select Last, 2, and select Weeks from the option.
Power BI Date Slicer last weeks
Power BI Date Slicer last weeks

This is an example of Power BI Date Slicer last week.

Read Microsoft Power BI Alerts

Power BI Date Slicer last 7day

Here we will see how to set the last 7 days in the Date slicer in Power BI.

For this example, we will use the Relative date type in the Date slicer to get the previous 7 days in Power BI Desktop.

  • In Power BI Select the Slicer visual with the Date data.
  • Then in the Slicer visual-> select the down arrow -> select the Relative Date type.
  • Then select Last, 7, and select days from the option.
Power BI Date Slicer last 7 days
Power BI Date Slicer last 7 days

This is an example of Power BI Date Slicer last 7days.

Power BI Date Slicer week starts Monday

Here we will see an example Power BI Date slicer Week starts Monday.

For example, we will create a Slicer that has 2 options i.e. Weekday(Monday -Friday) and Weekend(Saturday and Sunday). So when you select Weekday, You can see the date of Week starts from Monday.

  • In Power BI, create a new custom column that will get the day name from the date column.
Day = format(DAY(Sheet1[Date]), "dddd")
  • Next, create another custom column to calculate the Weekday and Weekend, by using the below formula.
Weekdays = If(Sheet1[Day]="Monday", "Weekday",IF(Sheet1[Day]="Tuesday","Weekday",IF(Sheet1[Day]="Wednesday","Weekday",IF(Sheet1[Day]="Thursday","Weekday",IF(Sheet1[Day]="Friday","Weekday",IF(Sheet1[Day]="Saturday","Weekend",IF(Sheet1[Day]="Sunday","Weekend")))))))
  • Now, select the Slicer visual, from the visualization pane, then drag and drop the Weekdays column from the Field pane to the Field in the Visualization pane.
  • Then select the Weekdays from the slicer, and if you are using the Date column, then sort the Date in ascending order. You can see it every week starting from Monday.
Power BI Date Slicer week start monday
Power BI Date Slicer week start Monday

This is an example of Power BI Date Slicer week start monday.

Read Export Power BI Reports to Excel

Power BI Date Slicer quarter

Here we will see how to create a date slicer quarter in Power BI.

For this example, we will create a calculated column that will get the Quarter from the date column.

  • First, create a calculated column to get the Quarter by using the below formula:
QuarterName = Sheet1[Date].[Quarter]
  • Then select the slicer visual from the Visualization pane in Power BI.
  • Next, drag and drop the QuarterName column from the Field pane to Fields in the Visualization pane.
Power BI Date Slicer quarter
Power BI Date Slicer quarter

This is an example of Power BI Date Slicer quarter.

Power BI Date Slicer search

In the Power BI date slicer, it is not possible to search date because the search option is not available, like that in the text field slicer.

Power BI Date Slicer showing future date

Here we will see how to restrict the future date showing in the Power BI Date Slicer.

In the date column, I have dates from 09/1/2021 to 04/22/2023, so Today’s date is 5/17/2022. We will restrict the slicer to show the future dates, i.e. after 5/17/2022.

Power BI Date Slicer showing future date
Power BI Date Slicer showing future date

So to restrict the date to show the future date we will use the Visual level filter in the Filter pane.

  • For this, click on the Slicer, expand the Filter pane -> Under Filter on this Visual -> Expand the Date column -> Select the Filter type as Relative Date -> Show item when the value is in the last 360 days -> check the box Include Today. Then click on Apply Filter.
Date Slicer showing future date in Power BI
Date Slicer showing future date in Power BI

This is an example of Power BI Date Slicer showing future date.

Read Power BI Query Group Tutorial

Power BI date slicer default to Yesterday

Here we will see how to set the Power BI Date slicer default to Yesterday.

To set the slicer default to yesterday, follow the below steps:

  • In Power BI, create a new custom column, that will set the Yesterday date as Yesterday, by using the below formula.
Yesterday = 
  VAR __Yesterday = TODAY() - 1
RETURN
  IF(Sheet1[Date] = __Yesterday,"Yesterday",Sheet1[Date] & "")
  • Next, select the Slicer from the Visualization pane, then drag the Yesterday column from the Field pane into the Field in the Visualization pane.
  • Then Sort the Date as descending, you can see the yesterday, and it gets dynamically updated.
Power BI date slicer default to Yesterday
Power BI date slicer default to Yesterday

This is an example of Power BI date slicer default to Yesterday.

Power BI Sort date slicer ascending

Here we will see how to sort date slicer ascending in Power BI.

The sorting option in the date slicer is available for List and Dropdown types. So let’s see how to sort List type date Slicer in ascending order.

In Power BI create the Slicer with the date field, then in the Slicer click on the More icon (…) -> Click on Sort axis -> Sort ascending.

Power BI Sort date slicer ascending
Power BI Sort date slicer ascending

This is an example of a Power BI Sort date slicer ascending.

Read Power BI Change Data Type of a Column

Power BI Slicer clear selection

Here we will see how to clear selection in Power BI.

If we have selected the date in Power BI date slicer, to clear the selection, click on the eraser icon present in the slicer header.

Power BI Slicer clear selection
Power BI Slicer clear selection

This is an example of Power BI Slicer clear selection.

Power BI Slicer Current date

Here we will see an example of Power BI Slicer Current date.

  • In Power BI, select the Slicer with date field column -> click on the down arrow present in the slicer header -> select Relative date type.
  • Then set the Current date by selecting the option This day, like below.
Power BI SLicer Current date
Power BI SLicer Current date

This is an example of the Power BI Slicer Current date.

Read How to use Power BI Workbooks

Power bi multiple date slicer on one page

Here we will see how to create multiple slicers on one Page in Power BI.

For example, we will create date slicers for year and another for a month, if we want to filter the data for Dec 2021, then you can easily filter the data.

In Power BI create two calculated columns to get the Year and month from the date field by using the below formula:

Year = YEAR(Sheet1[Date])
Month = MONTH(Sheet1[Date])
  • Now create two slicers, and drag the Year and month column from the field pane.
  • Now you can select one slicer, it will filter another slicer to show the data valid for you.
  • For example, here I have selected 2021, in the date column we have dates from Sept to Dec. So it will filter the Month slicer, instead of showing 1-12, it will show 9-12.
Power bi multiple date slicer on one page
Power bi multiple date slicer on one page

This is an example of a Power bi multiple date slicer on one page.

Read Power BI Buttons

Power Bi relative date slicer

Let us discuss the relative date slicer and Date Filter in Power BI Desktop. By taking a simple example, I will show you how we can use the relative date slicer and date filter in PowerBI Desktop.

Here my Requirement is, I have a SharePoint Online List and this list is having so many items. From those items, I want to retrieve the last seven days of data records.

As per my requirement, I have to retrieve the last seven days of data records. But also, You can retrieve the last any days of the data records, the next days of data records, or today’s data records.

For that purpose, I have created a SharePoint Online List named Product Details. This list is having four columns:

  • Product Name (Title): This is the by default Title column. Just I have renamed it to Product Name.
  • Product Quantity: This column is the Number data type that I have created.
  • Product Bill Date: This column is the Date/Time data type.
  • Product Sales: This column is the Currency data type.

Also, I have entered a number of items into the Product Details List as in the below screenshot.

filter the date using power bi
filter the date using power bi

To visualize the data record of the SharePoint Online List, Select the Product Sales field value from the Fields section and select any chart for data visualization. Here in this example, I have taken a Stacked column chart from the Visualizations section.

Once you will add the field value in the chart, then the data chart will appear like the below screenshot.

filter date using power bi
filter date using power bi

Now in Power BI Report, We have to add the Date filter to retrieve the last seven days of the data record.

To add the Date Filter in Power BI Report, Choose Slicer from the Visualizations section and put the Product Bill Date field value in the Field. Once you will choose the slicer, then the chart will display as shown below.

NOTE:

You must ensure that your Date/Time field should be like this below format:
mm/dd/yyyy“. So that the Relative Sicer Filter will appear otherwise not.
date filter using power bi
date filter using power bi

Now to filter the data, click on the drop-down option which is present on the top of the slicer. Select Relative from the drop-down.

power bi relative date filter
power bi relative date filter

After selecting Relative, the Product Bill Date will appear as below. Here, you can choose either Last, Next, or This day from the drop-down option. Suppose, If you want the last 15 days record, So you can choose the Last option from the drop-down.

Secondly, Enter the number that you want to view the data record. Suppose, You want 15 days record, So you can put 15 over there.

And the Last thing you should know is what type of date you want to view the data records. Suppose, You want to 15 days, So you can choose Days from the drop-down.

power bi dynamic date filter
power bi dynamic date filter

As per my requirement, I want the last 7 days data record, That’s why I have entered 7. Now you can see in the below screenshot, that the other chart is displaying the total Product sales of the last 7 days.

set default value for slicer
set default value for slicer

At last, I have provided all the styles to the data visualization chart by using the Format section. As I have formatted styles like Font size, background color, font color, border, etc. Now my Report is looking like the below screenshot.

power bi relative date slicer
power bi relative date slicer

Power bi from to date slicer

Let us see how we can use to date slicer using between option in Power BI,

  • In this example, I am going to use the financial data, which contains a date column in it
  • Open Power bi desktop. Load the financial data by using the get data option.
  • From the visualization pane, Select the Slicer visual and choose the Between option and also the table visual so that if you filter any values in the Slicer visual the changes will be reflected in the Table visual.
  • Drag and drop the date hierarchy field into the slicer visual, and choose the between option. so that we can choose the from to option in the date slicer.
Power bi from to date slicer
power bi number of days between slicer
  • In the below screenshot, we can see that the power bi slicer date fields, from the slicer visual for the selected from date to date is display country and sales value in the Table visual.
  • We can use the slider to choose the two between dates and check the results in the table visual.
Power bi from to date slicer example
Power bi from to date slicer example

This is how to use from to date slicer using between option in Power BI.

In this Power BI Tutorial, we learned all about Date slicers with examples. The Examples are listed below.

  1. Power BI Slicer
  2. Power BI Date Slicer
  3. Power BI how to add Date Slicer
  4. Power BI Date Slicer as slider
  5. Power BI Date Slicer as list
  6. Power BI Date Slicer dropdown
  7. Power BI Date Slicer month year
  8. Power BI Date Slicer single date
  9. Power BI Date Slicer by month
  10. Power BI Date Slicer only shows dates with data
  11. Power BI Date Slicer between two dates
  12. Power BI Date Slicer default to today
  13. Power BI Date Slicer between the default value
  14. Power BI Date Slicer date and time
  15. Power BI Date Slicer for all pages
  16. Power BI Date Slicer relative and between
  17. Power BI Date Slicer by week
  18. Power BI Date Slicer by quarter
  19. Power BI Date Slicer current month
  20. Power BI Date Slicer for multiple columns
  21. Power BI get max date from the slicer
  22. Power BI get Date range from Slicer
  23. Power BI get generic date from slicer
  24. Power BI date slicer greater than
  25. Power BI Date Slicer horizontal
  26. Power BI Date Slicer date hierarchy month
  27. Power BI Date Slicer include blanks
  28. Power BI Date Slicer last 30 days
  29. Power BI Date Slicer last 12 months
  30. Power BI Date Slicer last weeks
  31. Power BI Date Slicer last 7days
  32. Power BI Date Slicer week start monday
  33. Power BI Date Slicer quarter
  34. Power BI Date Slicer search
  35. Power BI Date Slicer showing future date
  36. Power BI date slicer default to Yesterday
  37. Power BI Sort date slicer ascending
  38. Power BI Slicer clear selection
  39. Power BI Slicer Current date
  40. Power bi multiple date slicer on one page
  41. Power Bi relative date slicer
  42. Power bi from to date slicer
>