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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.