Forum Discussion

fellin's avatar
fellin
Regular Visitor
5 years ago

Dynamic hierachical x-Axis based on measure value

Hey all,

I want to have a x-axis in a column chart, which automatically drills down to the next level of a ragged hierchay which i slice via the hierachy slicer. Its possible to slice my data via the hierachy slicer and then manually drill down in the column chart to a certain level, but to make it as easy as possible for the user, I want this to be done automatically. 

I have Dimensions Department table which contains my ragged hierachy and a fact table which contains every action as rows. 

I've already tried these things:

1. Create bookmarks to visualize the different levels, but there is no possibilty to trigger an action by a measure or sth else.

2. Create a calculated column which checks if the selected Level,which i can get over a measure, is  the same level as the level of the Department minus 1, but this is not dynamically.

3. When I want to create a measure to check if the level of a certain Department minus 1 is the same as the level selected, but then i get problems, that a measure only exist in the value dimensions and not in collumns.

 

Is there a possible way to archieve a solution for this problem?

 

Thank you in advance!

 

 

4 Replies