+ Reply to Thread
Results 1 to 4 of 4

Excel Timeline Slicer not working in formula for days

  1. #1
    Valued Forum Contributor TheCman81's Avatar
    Join Date
    11-06-2012
    Location
    Edinburgh, UK
    MS-Off Ver
    Excel 2003, 2007, 2010, 2013
    Posts
    346

    Excel Timeline Slicer not working in formula for days

    Afternoon.

    I have a CUBEVALUE formula that I use to pull figures from a PowerPivot model, and I use a Timeline Slicer (not regular Slicer) to slice the dates.

    It works fine when slicing using YEAR/QUARTERS/MONTHS and even multiple selections in the DAYS section, but as soon as I select a single day, it doesn't work, I get an N/A error. There is values for the selected day, I've checked multiple days and it doesn't work on a single day selection.

    Anyone know what the issue is?

    Thanks
    Excel Guru in the making

    <----------If the question has been answered to your satisfication please click the Add Repuation star to the left

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Excel Timeline Slicer not working in formula for days

    Hard to say without seeing it.

    Can you attach a sample workbook?

  3. #3
    Valued Forum Contributor TheCman81's Avatar
    Join Date
    11-06-2012
    Location
    Edinburgh, UK
    MS-Off Ver
    Excel 2003, 2007, 2010, 2013
    Posts
    346

    Re: Excel Timeline Slicer not working in formula for days

    Sorry I didn't reply when I first asked this question as I found a workaround by adding a Calculated Column in my Date Table with the formula =TRUE() and brought that into my CUBEVALUE formula as CUBEMEMBER.

    This issue only happens with a TimeLine slicer with the CUBEVALUE formual.

    Everyone I speak to about this is weirded out by it and some, including myself wants to know what the issue is?

    Anyway, I've attached a sample workbook with data just for Jan 2019.

    You'll see when you click on the TimeLine just for single days it returns an error, if you select multiple days or months/years, it works fine.

    Thanks
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    03-31-2012
    Location
    England
    MS-Off Ver
    Office365
    Posts
    2

    Re: Excel Timeline Slicer not working in formula for days

    Did you ever get a resolution to this?

    I am not an advanced user but looking to do a similar thing by getting data selected in a timeline, but it just doesn't work. Similar to what you were/are seeing, I get an N/A

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Error with timeline slicer
    By fuerte in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-16-2018, 08:37 PM
  2. Formula to show/reference selected value by slicer/timeline
    By Mau_rice89 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-17-2017, 10:51 AM
  3. timeline slicer for months only
    By zico8 in forum Excel Charting & Pivots
    Replies: 15
    Last Post: 10-26-2016, 03:30 AM
  4. [SOLVED] Timeline/Slicer refresh issue
    By PFDave in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 09-02-2016, 10:05 AM
  5. Timeline and Slicer Help
    By PFDave in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-16-2016, 06:44 AM
  6. Timeline slicer connection question
    By jugdish in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-19-2015, 02:19 PM
  7. Timeline Slicer custom fiscal period
    By pinebush in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-16-2014, 10:57 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1