Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
This is a 5-level balance sheet hierarchy and it works perfectly if the 5 levels are used. The problem is when I only have 3 or 4 levels of data. I get a blank row because I have blanks in the empty cells for the 4-5 level. I would like to know if there is a way to stop the dropdown before the blank cell. I am attaching a screenshot of the matrix.
Thanks for the help!
Solved! Go to Solution.
@Anonymous,
See the link below:
https://www.daxpatterns.com/parent-child-hierarchies/
Proud to be a Super User!
@Anonymous,
See the link below:
https://www.daxpatterns.com/parent-child-hierarchies/
Proud to be a Super User!
User | Count |
---|---|
84 | |
80 | |
70 | |
47 | |
43 |
User | Count |
---|---|
108 | |
54 | |
50 | |
40 | |
40 |