Forum Discussion
BugmanJ
4 years agoHelper V
Powerbi Matrix Hide Values in Rows but show in Values?
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?
2 Replies
- amitchandakSuper User
- BugmanJHelper V
Doh, Thank you