Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hi.
Is it possible to show a matrix with the two first columns fixed/frozen and the weeks columns change update in one table
Thanks
| WEEK1 | WEEK2 | WEEK3 | ||
| SALES | $1,000 | $500 | $600 | $800 |
| GOAL 1 | 85% | 50% | 60% | 80% |
| GOAL 2 | 90% | 50% | 60% | 80% |
| GOAL 3 | 100% | 50% | 60% | 80% |
Hi @jsim100 ,
Based on my test, we cannot achieve that by a matrix. Maybe we can create two tables to work around.
| User | Count |
|---|---|
| 54 | |
| 37 | |
| 27 | |
| 17 | |
| 16 |
| User | Count |
|---|---|
| 69 | |
| 57 | |
| 38 | |
| 21 | |
| 21 |