Forum Discussion
hierarchy data display
I have a source date like this
when I put into powerbi to display it by matrix
and I don't want the blank position display in it .
What i want just like this (I make it in excel)
Can any expert can help about this?
Thanks.
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!
7 Replies
yanzhao_LBS , Try the Stepped Layout off
Matrix Visual: https://www.youtube.com/watch?v=M5PvQUy-L_4&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=28
hello, Thanks for your reply ,As I cannot open the youtube ,can you give me more details about the solution?
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.
