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
    Location
    USA
    Posts
    2
    Articles
    0

    Power BI Nesting Hierarchy Indicator to Match Power Pivot



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

    hi,
    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:	9 
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
    Posts
    164
    Articles
    0
    Excel Version
    2016
    Kalyanbl

    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)


    https://www.screencast.com/t/mjDhgSBEPda

    Knock 'em dead Tiger!
    Last edited by Ed Kelly; 2018-03-09 at 08: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
  •