+ Reply to Thread
Results 1 to 2 of 2

How to link Timeline and Slicers in pivot table

  1. #1
    Registered User
    Join Date
    07-03-2019
    Location
    Sydney
    MS-Off Ver
    2016
    Posts
    1

    How to link Timeline and Slicers in pivot table

    Hi All,

    I am creating Pivot table report from Power BI Data Model. I have many filters(Slicers) and Timeline. i am using Date as Timeline and Invoice date, products ... as slicers. Both of them work fine with pivot table, but there is no cascading effect from Timeline to Slicer or vice versa. for example, if i select 2019 as range in Timeline, Slicer should show Invoices dates, products for 2019, but it is not. How do i create connection between Timeline and Slicers.

    Thanks,
    Vincent
    Last edited by Vincent Katta; 07-03-2019 at 09:24 PM.

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: How to link Timeline and Slicers in pivot table

    Post your data model.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

+ 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. [SOLVED] Pivot Table & Slicers
    By Statz in forum Excel General
    Replies: 3
    Last Post: 10-09-2017, 09:35 PM
  2. Clear Slicers and Timeline at the same time
    By Acousticlife81 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-02-2017, 03:15 PM
  3. Timeline does not update other slicers without refresh all being run
    By PFDave in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-31-2017, 01:32 PM
  4. Timeline to filter with Slicers
    By PFDave in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-23-2016, 10:25 AM
  5. [SOLVED] Is there any way to tell if a pivot table has slicers?
    By ChemistB in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 03-07-2016, 12:56 PM
  6. [SOLVED] Disconnect Slicers, Change Pivot Table Source, Reconnect Slicers: a problem
    By Geoff. in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2015, 02:27 PM
  7. Replies: 2
    Last Post: 05-24-2013, 03:58 PM

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