Skip to main content

    Power BI

    New

    Hierarchy in legend

    Vote (66) Share
    Chris Bevan's profile image

    Chris Bevan on 22 Dec 2016 00:34:02

    When using a Hierarchy in the "Details" section of a chart you gain the ability to drill up and down that hierarchy. I would like to be able to place the same hierarchy in the "Legend" section of the chart so that my legend will update based on the level of the hierarchy I have drilled to.

    Comments (3)
    Chris Bevan's profile image Profile Picture

    95d73ebd 58a7-41b0-89f7-6c6b74978800 on 06 Jul 2020 00:13:20

    RE: Hierarchy in legend

    The captcha doesn't appear, so I can't vote

    Chris Bevan's profile image Profile Picture

    8bc1bada 6076-4ab5-9eda-a9b472c779ed on 05 Jul 2020 23:59:06

    RE: Hierarchy in legend

    Completely agree, we have a table with over 1 billion rows and the only work around I've found involved cross joining the names of the columns in the hierarchy to the table in question. Since we have 4 different columns we'd like to be able to switch between in the legend, this is currently quadrupling the size of this table.

    Chris Bevan's profile image Profile Picture

    a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:03:43

    RE: Hierarchy in legend

    For sure, that important for "Filled Map"