Forum Discussion
hierarchy data display
Hi yanzhao_LBS
Understood your problem.
Unfortunetly the solution you are asking to hide the cell which are blank is not possible in power bi.
In power Bi if you try tho remove the blank from table then compelte row will get removed.
which is not good solution beacuse it contain values which can not be ingnored.
I hope I answered your question!
Hi yanzhao_LBS
Just disable this stepped layout option of Row Header of Matrix visual.
I hope I answered your question!
Uzi2019 Thanks for your reply,
I tried that but didn't work.
stepped on:
stepped off:
still there is blank level.
Hi yanzhao_LBS
You have data against blank row. so need to fix the data first so that there wont be anyblank row.Take your all data in table visual and check which cell is blank.
the blank you see is the actual org scenario and not all of them have the 3 layer report just like AA , AA report to Mike,Mike report to Jerry,Jerry report to Jeff. DD only have 2 layer report (DD report to Mary,Mary report to Jeff). That's the reason why blank. And what I want is to hide the blank level. Do you know is that possible?
Hi yanzhao_LBS
Understood your problem.
Unfortunetly the solution you are asking to hide the cell which are blank is not possible in power bi.
In power Bi if you try tho remove the blank from table then compelte row will get removed.
which is not good solution beacuse it contain values which can not be ingnored.
I hope I answered your question!