Forum Discussion
VarunSuresh
3 years agoNew 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:
Path length < 7
Level definition:
Matrix Visual:
No RepliesBe the first to reply