Forum Discussion
Solved
Hierarchy remove blank from matrix
hello I would like to remove rows with blanks. So I created colunm remove blank and try to display only when this colums is 1 but the result that I have is wrong ...
Hi dfs29 ,
follow this article. After figure 7 is described how you can hide the rows with blank.
https://www.daxpatterns.com/parent-child-hierarchies/
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
That happens because the visual you've chosen has those many fields as rows. Probably other items make use of those levels of the hierarchy, but the item you've currently displayed stops at level 3. You should just collapse the item at that level to avoid seeing the other rows or, if further levels in the hierarchy are irrelevant, just delete them from the visual.