Forum Discussion
yanzhao_LBS
2 years agoHelper II
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)...
- 2 years ago
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!
amitchandak
2 years agoSuper User
yanzhao_LBS , Try the Stepped Layout off
Matrix Visual: https://www.youtube.com/watch?v=M5PvQUy-L_4&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=28
- yanzhao_LBS2 years agoHelper II
hello, Thanks for your reply ,As I cannot open the youtube ,can you give me more details about the solution?