Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Forum, I am trying to solve the following case:
Using the table below (coming from power query), I am trying to build two slicers for category and subcategory (DONE) and I am want to also use category and subcategory as a row and column in the same pivot table and be able to select an option via drop down (example of pivot table shown below).
| User | Count |
|---|---|
| 4 | |
| 4 | |
| 2 | |
| 2 | |
| 2 |
| User | Count |
|---|---|
| 15 | |
| 8 | |
| 6 | |
| 6 | |
| 5 |