R hierarchical slicer

[Shannon_Leong]

Hi community, I am trying to create a hierarchical slicer in RStudio. The slicer should look like the one in powerbi, that shows the ascending and descending parent child relationship, with around 5 or more hierarchy levels. (allow for multiple selection of entity code) Can anyone help, thank you! 

[Idrissshatila]

Hello @Shannon_Leong ,

refer to this video https://youtu.be/1Y0T_KkeWyQ?si=SQHa6ZNc0Ftv4coi

[Shannon_Leong]

Hi @Idrissshatila Thank you for replying. I am able to create a descending hierarchy just fine. However, due the logic of my data, i am not able to create a hierarchical slicer that will display the ascending hierarchy. Furthermore, I find that using the PATH() formula feels abit "hardcoded" therefore I am trying to find a more automated solution than what I have now. Below is a sample of my data, Thank You! 

EntityCode	ParentCode	Path	ReversePath1	ReversePath2	ReversePath3
1001	1001	1001	1001
1002	1001	1001|1002	1002	1001
1003	1001	1001|1003	1003	1001
1004	1001	1001|1004	1004	1001
1005	1001	1001|1005	1005	1001
1006	1003	1001|1003|1006	1006	1003	1001
1007	1003	1001|1003|1007	1007	1003	1001
1008	1004	1001|1004|1008	1008	1004	1001
1009	1004	1001|1004|1009	1009	1004	1001

[Idrissshatila]

@Shannon_Leong ,

try putting these three columns in one slicer above each others, or if you want them in a visual put them above each others.

[Shannon_Leong]

Hi @Idrissshatila, I have tried to do so. However, the slicer did not filter my legal entity chart as the entity codes are grouped in its unique values... To explain (based on the table below), if i were to write the first SQL statement, I would get 2 rows in my output. If i wrote the second statement, I would get 8 rows in my output... I hope this gives a rough idea of the logic behind my data. Thank you!

SELECT*FROM Table 1 GROUPBY Level 1
SELECT*FROM Table 1 GROUPBY Level 2

Level 1	Level 2
a	1
a	2
a	3
a	4
b	5
b	6
b	7
b	8