Timeline slicer showing only available dates RRS feed

  • Question

  • Hi!

    Is there anyway to have the timeline slicer only showing the available dates, instead of the full year/years?


    Let's say I have this single table in the data model:

    SoldItems Date
    3 2015-06-01
    4 2015-06-02
    5 2015-06-03
    6 2015-06-04

    As you can see, the date range is between 1 June to 4 June, only four days. However, when adding a timeline slicer to this table, the timeline slicer gives the user the possibility to change any dates in the full year 2015. It would be more appropriate, I think, in most cases to only enable the actual date range (1 June to 4 June).

    Is this possible?




    Wednesday, September 30, 2015 8:55 PM


  • No. The timeline will always fill an entire calendar year with missing dates. If this is a dealbreaker for you, use a slicer or series of slicers (year, month, date) all set to hide items with no value, and you can get pretty equivalent functionality and ease of use with a small sacrifice of real estate.

    GNet Group BI Consultant

    • Proposed as answer by greggyb Thursday, October 1, 2015 4:31 AM
    • Marked as answer by FredGun Thursday, October 1, 2015 10:56 AM
    Wednesday, September 30, 2015 9:25 PM