Forum Discussion

VarunSuresh's avatar
VarunSuresh
New Member
3 years ago

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:

Path length < 7

Level definition:

Matrix Visual:

 

No RepliesBe the first to reply