Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Can Hierachy by dynamic ?

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

 

 

  • 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. 

1 Reply

  • 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.