Matrix Table Issue

[cham]

Hi,

I have issue with Matrix table. I have main record as State and tehre is a another record called Sub which I need to show as drill down in State. But Only State is showing in my matrix table and not showing sub as drill down.

This is how its showing now. But I need to add East and West under QLD.

Can someone help me for this.

Thanks,

C

[V-lianl-msft]

Hi @cham ,

This is not difficult. Is the reason why you can't do this related to the data model? Generally speaking, Put two columns in the row field of the matrix to realize the hierarchy.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sevenhills]

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual