hierarchy data display

[yanzhao_LBS]

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.

[Uzi2019]

Hi @yanzhao_LBS 

Just disable this stepped layout option of  Row Header of Matrix visual.

I hope I answered your question!

[yanzhao_LBS]

@Uzi2019 Thanks for your reply,

I tried that but didn't work.

stepped on:

stepped off:

still there is blank level.

[Uzi2019]

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.

[yanzhao_LBS]

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?

[Uzi2019 · Accepted solution]

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]

@yanzhao_LBS , Try the Stepped Layout off

Matrix Visual: https://www.youtube.com/watch?v=M5PvQUy-L_4&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=28

[yanzhao_LBS]

hello, Thanks for your reply ,As I cannot open the youtube ,can you give me more details about the solution?