Forum Discussion
Hierarchy stop at Certain Point
Hi Team
I want to stop hieararchy at certain point for example if I select justin then it should stop till Justin and show hierarchy till the reportees of Justin.I want in same fashion at shown in First screenshot so how to do I have tried certain methods and technique. But none is working can you help me to get this resolved
Hi Anonymous ,
Thnaks for reaching out to Microsoft Fabric Community.
Apologies for delayed response. If your query is still unresolved, here's some guidance that may help.From your explanation, it seems you want the slicer to display only the selected employee (e.g., Justin) and their reportees, while hiding the levels above. Currently, slicers in Power BI, including the hierarchy slicer, don’t support dynamic filtering of their own values based on selection. Slicers can filter visuals but not themselves.
A possible approach is to use a separate selector slicer to choose the employee, and then use DAX logic with functions like PATH and PATHCONTAINS to build a filtered view that includes only that employee and their reportees. This filtered result can be connected to a secondary slicer or used in visuals to reflect the intended hierarchy.
That said, if you found a solution that helped achieve your requirement, please consider sharing it here to help the community.
If you found this post helpful, please mark it as Accepted Solution to assist others with similar queries. A kudos would also be greatly appreciated.
Thank you.
7 Replies
ExcelMonkeImpactful Individual
Hello,
I don't know if I quite understand the problem fully, but based on what you are describing, you could consider using the SELECTEDVALUE function for your calculations. But I'd have to know a bit more about the backend data, what you've tried, and a bit clearer understanding of what you're trying to achieve.
P.S. I would also recommend to not use confidential corporate data in your screenshots, etc...HI ExcelMonke
Basically I have one table with columns L1-L15 , HIERARCHY LEVELS , Employee Email , Employee name , pattopdownstring - which is separated by commas , so basically I have already build Hierarchy slicer with search option enabled so currently if I search anyone for example Justin then I am able to see justin and everything in the hiearchy and sometimes I have to expand and search the person in that hierarchy so as per previous post I have attached screenshot so basically what I am trying to achieve is that if I am searching justin simpson then hierarchy should stop at that level and show till justin and its reportees so how to achieve this>
I have used certain DAX formulas including DAX formulas but not able to achieve it the end result can you help me to do so?- ExcelMonke
I think I understand what you're trying to achieve - Is there a particular reason why you need the full hierarchy in the slicer, rather than just the levels you want? E.g. just have level 1, and 2?
v-veshwara-msftCommunity Support
Hi Anonymous ,
Thnaks for reaching out to Microsoft Fabric Community.
Apologies for delayed response. If your query is still unresolved, here's some guidance that may help.From your explanation, it seems you want the slicer to display only the selected employee (e.g., Justin) and their reportees, while hiding the levels above. Currently, slicers in Power BI, including the hierarchy slicer, don’t support dynamic filtering of their own values based on selection. Slicers can filter visuals but not themselves.
A possible approach is to use a separate selector slicer to choose the employee, and then use DAX logic with functions like PATH and PATHCONTAINS to build a filtered view that includes only that employee and their reportees. This filtered result can be connected to a secondary slicer or used in visuals to reflect the intended hierarchy.
That said, if you found a solution that helped achieve your requirement, please consider sharing it here to help the community.
If you found this post helpful, please mark it as Accepted Solution to assist others with similar queries. A kudos would also be greatly appreciated.
Thank you.- v-veshwara-msft
Hi Anonymous ,
Just checking in to see if you query is resolved and if any responses were helpful. If so, kindly consider marking the helpful reply as 'Accepted Solution' to help others with similar queries.
Otherwise, feel free to reach out for further assistance.
Thank you.
- v-veshwara-msft
Hi Anonymous ,
Following up to see if your query has been resolved. If any of the responses helped, please consider marking the relevant reply as the 'Accepted Solution' to assist others with similar questions.
If you're still facing issues, feel free to reach out.
Thank you.
- v-veshwara-msft
Hi Anonymous ,
We’re following up once more regarding your query. If it has been resolved, please mark the helpful reply as the Accepted Solution to assist others facing similar challenges.
If you still need assistance, please let us know.
Thank you.