Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
NKotak_Leecare
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.

 

Cheers,

Nidhi, @ssingh_leecare 

1 REPLY 1
v-janeyg-msft
Community Support
Community Support

Hi, @NKotak_Leecare 

 

 

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

vjaneygmsft_0-1646383149520.png

vjaneygmsft_1-1646384070683.png

 

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

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors