VBA Express Forum - Excel BIhttp://www.vbaexpress.com/forum/
A forum to help the understanding Business Intelligence for Excel.enTue, 14 Aug 2018 21:56:01 GMTvBulletin60http://www.vbaexpress.com/forum/images/misc/rss.pngVBA Express Forum - Excel BIhttp://www.vbaexpress.com/forum/
http://www.vbaexpress.com/forum/showthread.php?63413-Slicer-using-relationship-quot-levels-quot&goto=newpost
Mon, 13 Aug 2018 12:54:18 GMTHello. Please see attached spreadsheet. What I would like to do is add all categories levels into my slicer. So my slicer would ultimately look like this...
* AFC East
* AFC North
* AFC South
* AFC West
* NFC East
* NFC North
* NFC South
* NFC West

Hello. Please see attached spreadsheet. What I would like to do is add all categories levels into my slicer. So my slicer would ultimately look like this...

AFC East

AFC North

AFC South

AFC West

NFC East

NFC North

NFC South

NFC West

AFC

NFC

NFL

Currently, my slicer does not have the categories in bold.

Is it possible to build a slicer like this using the Power Pivot data model?