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
GhanshyamK
New Member

PowerBI matrix get the detailed value as per hierarchy data

I have below table 

Estate_CodeBlock_CodeCore_CodeCluster_CodeUPRNAsset_LevelAddressPost_Code
ACO701NULLNULLNULLNULLESTATENW6 5BANW6 5BA
ACO701ACO603NULLNULLNULLBLOCKNW6 5BANW6 5BA
ACO701ACO603NULLNULL23021986PROPERTYTHE TIN TABERNACLE 12-16  NW6 5BA
ACO701CAM510NULLNULLNULLBLOCKNW6 5BANW6 5BA
ACO701CAM510NULLNULL58015470PROPERTYFLAT A  18   NW6 5BANW6 5BA
ACO701CAM510C1CAM510NULLNULLCORENW6 5BANW6 5BA
ACO701CAM510C1CAM510NULL58015472PROPERTYFLAT C  18  NW6 5BA
ACO701CAM510C1CAM510NULL58015473PROPERTYFLAT D  18  NW6 5BA
ACO701CAM510C1CAM510NULL58116205PROPERTYFLAT B  18  NW6 5BA

 

I am creating a matrix report the get the hierarchy like 

GhanshyamK_0-1689603128581.png

now in the expand button if estate is selected it should show address,asset leve and post code of the estate on drilling down it should show the address of block and so on to UPRN. that is property. 

and if there is no core and cluster then the UPRN should come directly under block. 

Any help is appreciated 

Thanks in advance!

0 REPLIES 0

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

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!

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.