Single row in matrix view

Power BI Data Model
1

I want to have a single row on a matrix grid that show all customer on columns for an inventory ID. That is simple to do but what I want is to have other attributes of that inventory item (desc, MSRP, Avail QTY) show up in column without it creating a drill down hierarchy. I can not see how to do that, is this possible? Thanks.

2

Can you add some images of where you’re at currently, it’s difficult to imagine everything at play here. Thanks

3

Power%20BI%20avail
Power BI avail.png1920×1080 123 KB

Would like to have Attributes of InventoryItems Such as Selling Price, Lead time, Etc. appear next to InventoryID without having to drill down

4

Oh ok, this shouldn’t be too difficult,

All you need to do is select this

image

That’s it really.

Give it a go.

5

That would have been simple but that just expands the hierarchy does not flatten

image
image.png1920×948 71.9 KB

6

Ok maybe I’m not understanding what you mean by ‘flatten’.

You can change the look of the matrix in the formatting section where it says ‘rows’. I think this should do it.

This is similar to the financial examples I’ve created. Like the below.