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!
Hello everybody,
Im trying to create a visualisation able to show the Sub total per seller, with different dates.
On my data table looks like that:
And i would like to have a visualisation ( a table or a matrix ) that shows the sub-totals per seller, as follows:
If i used a table, i cant have the subtotals by seller, and when i try to use a matrix, i think i have a problem with the aggregation of the dates ( i dont need to agregate dates) and the subtotals doesn't appears.
Do you know how i can achieve this?
thanks for your answer. Im trying to add the subtotals, as the 2nd image. When i change the row subtotals it doesn't change anything on my table. Also i have only things as FIRST VALUES.
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
| User | Count |
|---|---|
| 47 | |
| 45 | |
| 33 | |
| 33 | |
| 30 |
| User | Count |
|---|---|
| 138 | |
| 118 | |
| 59 | |
| 58 | |
| 56 |