Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Problem with table with expand/collapse

    Posted Dec 29, 2021 08:55 AM
      |   view attached
    Hello,

    I am new on here so hopefully I'm following all etiquette.

    I have pulled a table (example below left) into pbi that i would lie to display it something like (below right) in pbi desktop. Bassically i want to be able to expand and collapse 'Manager' and have the rest of the data on one row.

    If i use a matrix i don't seem to be able to keep the data underneath 'Manager' on one row.

    If I use a table i don't seem to be able to expand and collapse the 'Manager' field.

    My intention is to have slicers on this data and for a total of rows under each 'Manager' if possible.

    Could someone help? I've uploaded the pbi desktop file if that helps.

    Thankyou!!



    ------------------------------
    Andrew Robinson
    Data analyst
    Worrynot.com Inc.
    Edinburgh
    +44 7775 117328
    ------------------------------

    Attachment(s)

    pbix
    Example for forum.pbix   40 KB 1 version


  • 2.  RE: Problem with table with expand/collapse

    Top Contributor
    Posted Jan 04, 2022 02:39 PM
      |   view attached
    Hi @Andrew Robinson

    Try this, attached.


    ------------------------------
    Simon Lamb
    IT Consultant, Method Excel Ltd.
    ------------------------------

    Attachment(s)

    pbix
    Feedback from forum.pbix   42 KB 1 version


  • 3.  RE: Problem with table with expand/collapse

    Posted Jan 05, 2022 04:30 AM
    Thank you Simon,

    that's a really good way of getting round it. Thank you!

    ------------------------------
    Andrew Robinson
    Data analyst
    Worrynot.com Inc.
    Edinburgh
    +44 7775 117328
    ------------------------------