Hey,
i am new to powerbi and i want to pivot some columns in my visualization, i tried using matrix but it didn't worked for me
i have created a view in database which contains all the columns i want in my visualization.
this is the source data.
| SKU | category | vendor | store_type | Location | Onhand_count |
| abc | acc | cybox | Warehouse | Teterboro(095) | 10 |
| abc | acc | cybox | Warehouse | Attleboro(091) | 15 |
| abc | acc | cybox | Warehouse | Atlanta(600) | 8 |
| abc | acc | cybox | store | Danbury(054) | 5 |
| abc | acc | cybox | store | New York(001) | 4 |
| abc | acc | cybox | store | Paramus(020) | 3 |
| def | acc | cybox | Warehouse | Teterboro(095) | 5 |
| def | acc | cybox | Warehouse | Attleboro(091) | 5 |
| def | acc | cybox | Warehouse | Atlanta(600) | 10 |
| def | acc | cybox | store | Danbury(054) | 6 |
| def | acc | cybox | store | New York(001) | 8 |
| def | acc | cybox | store | Paramus(020) | 6 |
i want to create Tabular visualization on this dataset similar to below format.
| | | | Warehouses | Stores |
| Vendor | Category | SKU | Total | Teterboro (095) | Attleboro (091) | Atlanta (600) | Total | Danbury (054) | New York (001) | Paramus (020) |
| cybox | acc | abc | 19 | 5 | 6 | 8 | 12 | 5 | 4 | 3 |
| cybox | acc | def | 20 | 5 | 5 | 10 | 20 | 6 | 8 | 6 |
| | | | | | | | | | | |
| | | | | | | | | | | |
Can anyone help me figure out:
1. How to create column title using a column value(location Column).
2. How to put the store_type value as title.
Thanks,
Abhishek
