+ Reply to Thread
Results 1 to 2 of 2

How to create multi-level slicer

  1. #1
    Registered User
    Join Date
    06-24-2019
    Location
    Atlanta
    MS-Off Ver
    365
    Posts
    12

    How to create multi-level slicer

    Hello,
    Is there a way to create multilevel slicer?
    A
    a1
    a2
    a3
    B
    b1
    b2
    b3

  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 create multi-level slicer

    It's not possible in Excel. But it IS possible in Power BI, using a custom "Hierarchy Slicer" visual: https://appsource.microsoft.com/en-u...0?tab=Overview
    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. Format the second level of multi-level category axis - clustered chart
    By mushkitoes in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-04-2018, 09:30 AM
  2. Create dynamic multi level reference ID (eg. 1.1.1, 1.1.2 etc)
    By ChrisNor in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-10-2017, 11:33 PM
  3. [SOLVED] creating Multi-level list styles using existing multi-level list?
    By JimmyWilliams in forum Word Formatting & General
    Replies: 2
    Last Post: 08-28-2017, 12:21 AM
  4. Bill of Materials conversion from multi level to single level
    By susmitpatel in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-11-2013, 12:53 AM
  5. Multi level BOM
    By neorez in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-23-2010, 05:22 PM
  6. Using macro to convert single level BOM to Multi Level BOM
    By andrew_chong in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-07-2006, 04:57 PM
  7. [SOLVED] Can I create multi-level passwords for the same workbook
    By waterskyle in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-18-2005, 04:06 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