Forum Discussion

BugmanJ's avatar
BugmanJ
Helper V
4 years ago
Solved

Powerbi Matrix Hide Values in Rows but show in Values?

Hello All,

Some simple data:

WarehouseTypeProduct
NorthFruitOranges
NorthFruitGrapes
NorthFruitApples
NotthNutsBrazil
NorthTowelsCotton
NorthSheetsCotton

 

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?