Using Number and Date Slicers in Power BI

Sep 15, 2022 | Power BI Hints and Tips

Slicers produce a user friendly filtering experience in Power BI Desktop. In an earlier blog I talked about Text slicers but Number and Date slicers are a little different. An example of what each could look like is shown below. 

Examples of date and number slicers

Adding a Number or Date Slicer 

    1. From the Visualisations Pane select the Slicer icon
Slicer icon

3. A Slider for that field will be produced 

4. Move the Slider end points or type in the boxes containing dates or numbers.  NOTE:  For date fields clicking in the box containing a date brings up the date picker which can be used instead 

Removing a Number or Date Slicer 

There are 2 ways to remove a Number or Date slicer. 

  1. Drag the slider end points back to the extreme left and right of the slider 
  2. Click on the Eraser that appears when you hover over the top right of the slicer visualisation 
Eraser

Changing the Number Slicer functionality 

By default a Number slicer is displayed as a Slider with both the start and end point being movable.  There are other options available though. 

  1. Hover over the top right of the Slicer Visualisation 
  2. Click on the drop-down arrow to see the options available (this appears after the eraser icon already mentioned).  There are 5 options 

a) List.  This provides a list of every number available in the data.  This is normally only suitable if there are a small number of possibilities. 

b) Dropdown.  This is similar to a list but initially a dropdown button is displayed and once selected the list of numbers appears 

c) Between.  This is the default and produced a slider with a start point and end point both of which can be moved 

d) Less than or equal too.  This is similar to Between but only the end point can be altered 

e) Greater than or equal to.  This is similar to Between but only the start point can be altered 

Number slicers

Changing the Date Slicer functionality 

By default a Date slicer is displayed as a Slider with both the start and end point being movable.  There are other options available though. 

  1. Hover over the top right of the Slicer Visualisation 
  2. Click on the drop-down arrow to see the options available (this appears after the eraser icon already mentioned).  There are 7 options 

a) Between.  This is the default and behaves a previously described 

b) Before.  This is similar to between but only the end point can be moved 

c) After. This is similar to between but only the start point can be moved 

d) List.  This provides a list of every date available in the data.  This is normally only suitable if there are a small number of possibilities. 

e) Dropdown.  This is similar to a list but initially a dropdown button is displayed and once selected the list of dates appears 

f) Relative Date.  This allows for the last, next or this number of days, weeks, months or years to be viewed so perfect for analysing what happened last month or this week without having to enter specific dates 

g) Relative Time.  This is similar to Relative Date but is related to minutes and hours 

Date Slicers

Formatting the Number and Date Slicer 

Like all visualisations in Power BI there are options that can be altered to change how the visualisation looks and behaves. 

  1. Click on the slicer visualisation already produced 
  2. Click on the Format your Visual tab in the Visualisation Pane 
Format slicer

Further Reading

If you’ve enjoyed reading about how to use Number and Date Slicers in Microsoft Power BI, there’s some other blogs below that you might find useful:

Want to learn more about Power BI? Then email lara@laramellortraining.co.uk to discuss how I can help or have a look at the Microsoft Power BI Courses I run.