Forum Discussion

cpatterson's avatar
cpatterson
Icon for Helper I rankHelper I
7 years ago

Inline Hierarchy - 100% Stacked Bar Chart

Hello,

 

I am using a 100% stacked bar chart with three levels of data and trying to remove the inline hierarchy. I would like it to only show the data at the level I am on. It only recently started displaying the inline hierarchy, so I'm not sure what happened as I have not changed anything or installed any updates. I tried to change the visual to a clustered chart and turn off the contactate feature, but this did not work.

 

On my axis I have Region > Location > Course Name. When I enable drill down and click on one of my regions, it then shows [Region] [Location]. When I click on a location, it shows [Region] [Location] [Course Name]. If I select "go to the next level of hierarchy" it displays [Location] but for all regions. 

 

Need Help

2 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    7 years ago

    Hi cpatterson ,

    Normally, if we click this icon highlight in red is Expand all down one level in the hierarchy, if we click green icon is go to next level.

     

    Here is my test result for the two scenario. 

    Is this your desired?

    Best  Regards,

    Cherry

    • cpatterson's avatar
      cpatterson
      Icon for Helper I rankHelper I
      7 years ago
      Hi Cherry,

      I would like it to stay filtered by [Region] when I click those. If I click the red one it shows all [Locations] and if I click the green one it still lists [Region] [Location].