Show different value on each hierarchy in Matrix Visualization

[claudia-amm]

Hi everyone.

I'm trying to make a table/matrix like this. This is an example from excel.

 

The requirement will be like this:

I have one hierarchy ID_Order, it has one child (item_no).

If I don't do expand or drill down, the description shows only "A" (order_desc). If I expand, then the description for ID_Order will shows "A" and item_no shows "B" (item_desc). It will show different value.

While on the Power BI, the matrix visual works like this (each hierarchies shows same value).

Can PowerBI do that?

Thanks a lot.

[Icey]

Hi @claudia-amm ,

What is the data structure of your raw data? Please give us some sample data with the same structure for testing.

Best Regards,

Icey