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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

How to display children of parent using hierarchy slicer?

EDIT 1: Strange, I am not able to attach pbix here.

----

Hi,

I am using Hierarchy slicer to show a hierarchy of sales. But when I select a parent, I want to display it's children in the table component. Kindly let me know how can I achieve it? Attaching pbix.

Following is the data :

NationalLevelStateLevelTerritoryLevelBrickLevelGeoIdSales
NationalNSWClintClintLvl41189
NationalNSWClintClintLvl42250
NationalNSWClintClintLvl43359
NationalNSWClintClintLvl44454
NationalNSWClintClintLvl45520
NationalNSWClintClintLvl46695
NationalNSWClintClintLvl47792
NationalNSWClintClintLvl48884
NationalNSWClintClintLvl49966
NationalNSWClintClintLvl501058
NationalNSWDarrelDarrelLvl411174
NationalNSWDarrelDarrelLvl421211
NationalNSWDarrelDarrelLvl431333
NationalNSWDarrelDarrelLvl441434
NationalNSWDarrelDarrelLvl451597
NationalNSWDarrelDarrelLvl461676
NationalNSWDarrelDarrelLvl471757
NationalNSWDarrelDarrelLvl481855
NationalNSWDarrelDarrelLvl491968
NationalNSWDarrelDarrelLvl502093
NationalQLDQClintQClintLvl412197
NationalQLDQClintQClintLvl422269
NationalQLDQClintQClintLvl432377
NationalQLDQClintQClintLvl442451
NationalQLDQClintQClintLvl452537
NationalQLDQClintQClintLvl462689
NationalQLDQClintQClintLvl472731
NationalQLDQClintQClintLvl482896
NationalQLDQClintQClintLvl492996
NationalQLDQClintQClintLvl503011
NationalQLDQDarrelQDarrelLvl413150
NationalQLDQDarrelQDarrelLvl423292
NationalQLDQDarrelQDarrelLvl433374
NationalQLDQDarrelQDarrelLvl443484
NationalQLDQDarrelQDarrelLvl453548
NationalQLDQDarrelQDarrelLvl463625
NationalQLDQDarrelQDarrelLvl473711
NationalQLDQDarrelQDarrelLvl483850
NationalQLDQDarrelQDarrelLvl493964
NationalQLDQDarrelQDarrelLvl504016

 

Desired output:

When first level is selected, I want to show 2nd level children in the table and when i select 2nd level, i want to show 3rd level row and so on:

Capture1.PNGCapture2.PNGCapture3.PNGCapture4.PNG

 

 

To achieve, above structure in table, I had to manually choose different columns in table for different levels. How can this be made dynamic?

 

 

 

 

2 REPLIES 2
v-lili6-msft
Community Support
Community Support

hi, @Anonymous 

According to my knowledge, I'm afraid that it couldn't achieve it in power bi for now.

You could only manually choose with Drill mode in a visualization in Power BI

https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
mussaenda
Super User
Super User

If nothing is selected? how will you show the data?

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors