Can Hierachy by dynamic ?

[Paulyeo11]

Hi All

it there a way i can set the hierachy dynamic.

For Excepted  :-

Brand

- select Brand A or B ( user can have a choice )

Company or Segment ( User can have a choice )

Instead of Now is folowing sequences :-

Brand

Company

Segment 

Paul Yeo

[ctaulbee · Accepted solution]

Hi Paul,

A dynamic Hierarchy is not possible in a traditional sense. There is no way to have a slicer that when selected changes which hierarchy is applied. 

However, there is a way to accomplish what you're trying to do by using bookmarks. By creating a button for the 2 different scenarios, and 2 versions of the visual using the 2 hierarchies, you can simulate a slicer experience. 

When one bookmark is selected, it hides the other visual and shows the desired visual, and vise versa.