Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live 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 |
|---|---|
| 53 | |
| 40 | |
| 35 | |
| 24 | |
| 22 |
| User | Count |
|---|---|
| 135 | |
| 111 | |
| 57 | |
| 44 | |
| 38 |