Adding slider selectors

Slider selectors add more flexibility for filtering the numeric or date type of data, though this selector can be used on any type of data.

Getting ready

Let's use the sample file Sample – Superstore Sales (Excel). Open a new worksheet and select Sample – Superstore Sales (Excel) as the data source.

How to do it...

Once the data is loaded on the worksheet, perform the following steps to add slider selector to your visualization:

  1. Click on the Show Me button to bring the Show Me toolbar on the screen.
  2. While holding the Ctrl key, click on Customer Segment and Category from Dimensions and Sales from Measures.
  3. Click on the circle views icon on the Show Me toolbar.
  4. Right-click on Order Date from Dimensions and select Show Quick Filter to show a multiple checkbox selector as shown in the following screenshot:
    How to do it...
  5. On the YEAR(Order Date) quick filter box, click on the small drop-down arrow to modify the filter properties.
  6. Select Slider from this box to add a slider filter as shown in the following screenshot:
    How to do it...
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset