Results 1 to 2 of 2

Thread: Power BI Nesting Hierarchy Indicator to Match Power Pivot

  1. #1
    Neophyte kalyanbl's Avatar
    Join Date
    Mar 2018

    Power BI Nesting Hierarchy Indicator to Match Power Pivot

    Register for a FREE account, and/
    or Log in to avoid these ads!

    we have a client that is accustomed to seeing hierarchy nesting in Power Pivot using Excel that looks and behaves like this:

    Click image for larger version. 

Name:	zXoVi.jpg 
Views:	10 
Size:	15.2 KB 
ID:	7818

    Specifically, they love the plus/minus expand/collapse functionality.

    We are now moving to Power BI which has a different philosophy when it comes to navigating a hierarchy. However, my client really likes the plus/minus paradigm in Power Query. Has anyone ever run across this before and come up with a workaround?

    Thank you

  2. #2
    Conjurer Ed Kelly's Avatar
    Join Date
    Jul 2016
    Excel Version

    Not sure this is quite what you had in mind, I get the +/-, use it a fair amount in pivot tables. Have not seen it within PBI however using a matrix maybe a workaround/1, using the drill down mini icon/2, will give you a layout of/3(which can go down 10+ levels if required), that you can navigate using arrows/4 or perhaps just interrogate it with use of slicer/5 or a visual representation/6.

    If this is way off, consider kicking it back to me with a question (although not regularly on this site)

    Knock 'em dead Tiger!
    Last edited by Ed Kelly; 2018-03-09 at 07:54 PM.

Tags for this Thread

Posting Permissions

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