Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper III
Helper III

From Hierarchy slicer when parent node is selected in the graphs display the child node

I have a hierarchy slicer for facility filter. So when nothing is selected from the filters the graph displays the parent node - Facility. But when a Parent node is selected it shows all its child nodes - Units.


Below is the attached snapshot of the requirements:

Hierarchy Requirements.jpeg


The facility, units both has a different table and they are linked via facilityID (ltcOrganisationID). The relatioship is displayed below:


Relationship - Facility-Units.png


Please let me know if this is possible to do. If so, how it can be done.


Apprecitate your help and support in advance.



Nidhi, @ssingh_leecare 

Community Support
Community Support

Hi, @NKotak_Leecare 



There doesn't seem to be a direct way, but you can use the drill down button.




Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.


Best Regards,

Community Support Team _Janey


Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors