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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
VarunSuresh
New Member

Repeating values in PowerBI Hierarchy

Hello there,

I am trying to create a hierarchy in PowerBI. There can be upto 7 levels in the hierarchy. So, I've defined Path and the 7 levels. However, there are items with less than 7 levels (some even 1). The Matrix table shows the same values of the parent till level 7. Is there a way to control this recursion? Attaching screenshots below.

Thanks!

Path DAX:

VarunSuresh_0-1676961859940.png

Path length < 7

VarunSuresh_1-1676961970576.png

Level definition:

VarunSuresh_2-1676962001006.png

Matrix Visual:

VarunSuresh_3-1676962096293.png

 

0 REPLIES 0

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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