Forum Discussion

Regular Visitor

6 years ago

Hierarchical Display

Hi All, I have two pie charts(displaying current year & last year data) loaded with below hierarchy. Courntry -> State -> City When I am selecting the Country name in slicer, usually power BI will...

Super User

6 years ago

premsagar I don;t think you can auto drill down to next level based on slicer selection. may be you can take advantage of bookmarks

premsagar
Regular Visitor
6 years ago
parry2kThanks for the suggestion, But keeping bookmark for each hierachy based on slicer value may lead to the complex performance issue. Not sure,how can we achieive it through bookmarks!!!
- parry2k
  Super User
  6 years ago
  premsagar I understand bookmark can be too much to manage but I'm afraid if there is any other solution until we create another calculated table and use dynamix x-axis, there are posts and video of dyamic x-axis, may be you want to look at this. here is one for refernece.
  - premsagar
    Regular Visitor
    6 years ago
    Hi parry2k
    
    Thanks a lot for suggesting the solution. But, unfortunately that is not suitable solution in my requirements. As we are dealing with huge data, Also drilldown with Top N functionality. We are having 3 levels Country -> state -> city
    When cliking on Country need to show the State, Same as if we are clicking on State, data has to display in City level,
    with including drilldown functionality.
    
    Thanks Much!