Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I have below table
| Estate_Code | Block_Code | Core_Code | Cluster_Code | UPRN | Asset_Level | Address | Post_Code |
| ACO701 | NULL | NULL | NULL | NULL | ESTATE | NW6 5BA | NW6 5BA |
| ACO701 | ACO603 | NULL | NULL | NULL | BLOCK | NW6 5BA | NW6 5BA |
| ACO701 | ACO603 | NULL | NULL | 23021986 | PROPERTY | THE TIN TABERNACLE 12-16 | NW6 5BA |
| ACO701 | CAM510 | NULL | NULL | NULL | BLOCK | NW6 5BA | NW6 5BA |
| ACO701 | CAM510 | NULL | NULL | 58015470 | PROPERTY | FLAT A 18 NW6 5BA | NW6 5BA |
| ACO701 | CAM510 | C1CAM510 | NULL | NULL | CORE | NW6 5BA | NW6 5BA |
| ACO701 | CAM510 | C1CAM510 | NULL | 58015472 | PROPERTY | FLAT C 18 | NW6 5BA |
| ACO701 | CAM510 | C1CAM510 | NULL | 58015473 | PROPERTY | FLAT D 18 | NW6 5BA |
| ACO701 | CAM510 | C1CAM510 | NULL | 58116205 | PROPERTY | FLAT B 18 | NW6 5BA |
I am creating a matrix report the get the hierarchy like
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!
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 11 | |
| 9 | |
| 9 | |
| 6 | |
| 5 |
| User | Count |
|---|---|
| 27 | |
| 22 | |
| 20 | |
| 17 | |
| 12 |