Forum Discussion
JNYY
8 years agoAdvocate I
Multiple totals in table/matrix
Hi guys,
Does anyone know how can we add multiple totals at the bottom of a table/matrix?
E.g. I would like to have both Total Store Sales and Comparable Store Sales.
Is this achievable in Power BI?
frHey,
by default it's not possible to add "custom totals" to table visual.
I use one of the following tricks
- using a card visual that displays the value for the second measure and just a simple text box for the label
- using a 2nd table w/o column headers and other formatting options
Depending on the requirements for the formatting this approach can become somewhat tedious
Regarding
Tom
1 Reply
- TomMartensSuper User
frHey,
by default it's not possible to add "custom totals" to table visual.
I use one of the following tricks
- using a card visual that displays the value for the second measure and just a simple text box for the label
- using a 2nd table w/o column headers and other formatting options
Depending on the requirements for the formatting this approach can become somewhat tedious
Regarding
Tom