Forum Discussion
Dynamic hierarchy based on other visual
Hi PC20
If you want to dynamic change the hierarchy, you may need to create slicers.
e.g
1.create a new table
Table 2 = SUMMARIZE('Table',[L1],'Table'[L2],'Table'[L3],'Table'[L4])2.Then create a paramater
3.Then create a measure and put the measure to the para slicer visual filter
Measure = SWITCH(TRUE(),ISFILTERED('Table 2'[L3]),IF(3 IN VALUES(Parameter[Parameter Order]),1,0),ISFILTERED('Table 2'[L2]),IF(2 IN VALUES(Parameter[Parameter Order]),1,0),ISFILTERED('Table 2'[L1]),IF(1 IN VALUES(Parameter[Parameter Order]),1,0),1)
3.Then create a new measure
Measure 2 = CALCULATE(SUM('Table'[Col1]),FILTER('Table','Table'[L1] IN VALUES('Table 2'[L1])&&'Table'[L2] IN VALUES('Table 2'[L2])&&'Table'[L3] IN VALUES('Table 2'[L3])&&'Table'[L4] IN VALUES('Table 2'[L4])))put the paramater and the measure to the visual
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous It might not be a feasible option in my case. It is a Management chain hierarchy.
I have 10 levels in hierarchy ,with some of the levels containing more than 1000 values.
And client doesn't prefer the chosing the Slicer option. Ask is to make it completely dynamic.
Hi PC20
If you don't use the slicer, the function cannot implement, because the hierarchy cannot dynamically change wihtout the paramater slicer.
Best Regards!
Yolo Zhu