Dynamic Hierarchy Level in Visuals

Hi nunnc01 ,

This can be achieved using two disconnected tables and a measure with a switch formula:

• Add the following code for two tables:

Slicer =
UNION (
    ADDCOLUMNS (
        VALUES ( 'Table'[Area] ),
        "Type", "Area",
        "Group Level", "Division"
    ),
    ADDCOLUMNS (
        VALUES ( 'Table'[Dvision] ),
        "Type", "Division",
        "Group Level", "Service"
    ),
    ADDCOLUMNS (
        VALUES ( 'Table'[Service] ),
        "Type", "Service",
        "Group Level", "Team"
    ),
    ADDCOLUMNS (
        VALUES ( 'Table'[Team] ),
        "Type", "Team",
        "Group Level", "NODETAIL"
    )
)



X Axis Values =
UNION (
    ADDCOLUMNS (
        VALUES ( 'Table'[Area] ),
        "Type", "Area",
        "Group Level", "Division"
    ),
    ADDCOLUMNS (
        VALUES ( 'Table'[Dvision] ),
        "Type", "Division",
        "Group Level", "Service"
    ),
    ADDCOLUMNS (
        VALUES ( 'Table'[Service] ),
        "Type", "Service",
        "Group Level", "Team"
    ),
    ADDCOLUMNS (
        VALUES ( 'Table'[Team] ),
        "Type", "Team",
        "Group Level", "NODETAIL"
    )
)

• For your values add the following measure:

Values By next level =
SWITCH (
    SELECTEDVALUE ( Slicer[Type] ),
    "Division",
        CALCULATE (
            SUM ( 'Table'[Value] ),
            FILTER (
                ALL ( 'Table'[Area], 'Table'[Dvision] ),
                'Table'[Area]
                    IN VALUES ( 'X-Axis Values'[Area] )
                        && 'Table'[Dvision] IN VALUES ( Slicer[Area] )
            )
        ),
    "Area",
        CALCULATE (
            SUM ( 'Table'[Value] ),
            FILTER (
                ALL ( 'Table'[Service], 'Table'[Area] ),
                'Table'[Service]
                    IN VALUES ( 'X-Axis Values'[Area] )
                        && 'Table'[Area] IN VALUES ( Slicer[Area] )
            )
        ),
    "Service",
        CALCULATE (
            SUM ( 'Table'[Value] ),
            FILTER (
                ALL ( 'Table'[Team], 'Table'[Service] ),
                'Table'[Team]
                    IN VALUES ( 'X-Axis Values'[Area] )
                        && 'Table'[Service] IN VALUES ( Slicer[Area] )
            )
        )
)

• Now use the slicer talbe for your slicer and the X-Axis for your axis on the chart on the values place the measure result below and  in attach file

I finish the setup at Team level but you can setup this to multiple leves just need to add it to the measure.