Powerbi Matrix Hide Values in Rows but show in Values?

[BugmanJ]

Hello All,

Some simple data:

Warehouse	Type	Product
North	Fruit	Oranges
North	Fruit	Grapes
North	Fruit	Apples
Notth	Nuts	Brazil
North	Towels	Cotton
North	Sheets	Cotton

Now in the below picture, displayed as a table at the top

If then displayed in a matrix (1), it hides anything which is not the first row (its possible to see this by reversing the sorting A-Z) and hence you must put "Product" in both the rows and the values table (2). But what i really want is to have the visulsiation as 3, where the "Product" is not shown in the far left but is shown in the tables value area?

Any thoughts on how this could be achieved?

[amitchandak · Accepted solution]

@BugmanJ , Try Stepped layout - off

[BugmanJ]

Doh, Thank you