Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I am having a table where there are heirarchical parental levels to the Name column.
Level 1 | level 2 | Level 3 | Level 4 | Name |
A1 | B1 | Activity 1 | ||
A1 | B2 | C1 | D1 | Activity 2 |
A2 | B3 | C2 | Activity 3 | |
A3 | Activty 4 |
When I create a matrix table, some of the parent levels of the name columns are blank. But the matrix table doesnt recognize this and creating a blank rows for each levels as shown below.
I wanted to remove the blank rows and only display the levels where there is a value as displayed below
While it is possible to prune dead branches with custom visuals you seem to want to collapse branches with dead parents. That is not currently possible in any visual, and it will most likely result in user confusion anyway. Better cleanup your data. There should be no blank parent elements in any hierarchy.
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
10 | |
6 |